In this lab you will learn and apply a five-step problem-solving process, use Microsoft Excel and...

Question

In this lab you will learn and apply a five-step problem-solving process, use Microsoft Excel and learn its basic applications for computation and graphing.

Lab #1 – Problem Solving With Microsoft Excel -Cable Car Velocity Objective: In this lab you will learn and apply a five-step problem-solving process, use Microsoft Excel and learn its basic applications for computation and graphing. Using a Five-Step Problem-Solving Process Computer tools are most effective in problem solving when a problem is broken into steps that the computer can perform. The problem-solving process introduced in this lab is based on a general five-step problem solving process, modified when using computer tools or programs such as Excel. General Problem-Solving Model Excel Problem- Solving Model 1. Define the problem. Problem statement. 2. Gather information. Input/output description. 3. Generate and evaluate potential solutions. Hand solve an example. 4. Refine and implement a solution Algorithm development. 5. Verify and test the solution Testing. Problem: Apply the five-step process above to solve the following problem. The velocity of a cable car as it moves along a 500-foot cable stretched between two towers is to be computed. The velocity of the cable car depends on its position on the cable. You are given equations below that approximate the velocity of the cable car as a function of distance of the cable from a tower. When the cable car is within 30 feet of a tower, its velocity is given by: You want to compute the velocity of the car from the time it starts moving from the first tower until it reaches the second tower, in increments of 5 feet. A. Prepare an Excel worksheet that tabulates the following 1. distance of the cable car from the first tower, in increments of 5 feet 2. the number of the nearest tower (1=first, 2=end) 3. distance from the nearest tower 4. 4. velocity of the cable car Note: The distance from the nearest tower, not the total distance, is used in the velocity equations. B. Create a scatter plot of the velocity of the cable car at different positions. C. What are the maximum and minimum velocities of the cable car? Prepare a brief technical memo including your design approach, data table, graph of cable car velocity vs. position, and answers to the questions.

lab1excel-cable-car-problem-tvahalew.pdf

Hanumantha Rao · Accepted Answer

Problem
	S. No	Position of car (ft.)	Nearest tower	Distance from nearest tower (ft.)	Velocity (ft./sec)
	1	0	1	0	2.425		Legend
	2	5	1	5	2.46875			Minimum Value
	3	10	1	10	2.6			Maximum Value
	4	15	1	15	2.81875					This document contains report of this exercise
	5	20	1	20	3.125
	6	25	1	25	3.51875
	7	30	1	30	4
	8	35	1	35	4.51875
	9	40	1	40	5.025
	10	45	1	45	5.51875
	11	50	1	50	6
	12	55	1	55	6.46875
	13	60	1	60	6.925
	14	65	1	65	7.36875
	15	70	1	70	7.8
	16	75	1	75	8.21875
	17	80	1	80	8.625
	18	85	1	85	9.01875
	19	90	1	90	9.4
	20	95	1	95	9.76875
	21	100	1	100	10.125
	22	105	1	105	10.46875
	23	110	1	110	10.8
	24	115	1	115	11.11875
	25	120	1	120	11.425
	26	125	1	125	11.71875
	27	130	1	130	12
	28	135	1	135	12.26875
	29	140	1	140	12.525
	30	145	1	145	12.76875
	31	150	1	150	13
	32	155	1	155	13.21875
	33	160	1	160	13.425
	34	165	1	165	13.61875
	35	170	1	170	13.8
	36	175	1	175	13.96875
	37	180	1	180	14.125
	38	185	1	185	14.26875
	39	190	1	190	14.4
	40	195	1	195	14.51875
	41	200	1	200	14.625
	42	205	1	205	14.71875
	43	210	1	210	14.8
	44	215	1	215	14.86875
	45	220	1	220	14.925
	46	225	1	225	14.96875
	47	230	1	230	15
	48	235	1	235	15.01875
	49	240	1	240	15.025
	50	245	1	245	15.01875
	51	250	1	250	15
	52	255	2	245	15.01875
	53	260	2	240	15.025
	54	265	2	235	15.01875
	55	270	2	230	15
	56	275	2	225	14.96875
	57	280	2	220	14.925
	58	285	2	215	14.86875
	59	290	2	210	14.8
	60	295	2	205	14.71875
	61	300	2	200	14.625
	62	305	2	195	14.51875
	63	310	2	190	14.4
	64	315	2	185	14.26875
	65	320	2	180	14.125
	66	325	2	175	13.96875
	67	330	2	170	13.8
	68	335	2	165	13.61875
	69	340	2	160	13.425
	70	345	2	155	13.21875
	71	350	2	150	13
	72	355	2	145	12.76875
	73	360	2	140	12.525
	74	365	2	135	12.26875
	75	370	2	130	12
	76	375	2	125	11.71875
	77	380	2	120	11.425
	78	385	2	115	11.11875
	79	390	2	110	10.8
	80	395	2	105	10.46875
	81	400	2	100	10.125
	82	405	2	95	9.76875
	83	410	2	90	9.4
	84	415	2	85	9.01875
	85	420	2	80	8.625
	86	425	2	75	8.21875
	87	430	2	70	7.8
	88	435	2	65	7.36875
	89	440	2	60	6.925
	90	445	2	55	6.46875
	91	450	2	50	6
	92	455	2	45	5.51875
	93	460	2	40	5.025
	94	465	2	35	4.51875
	95	470	2	30	4
	96	475	2	25	3.51875
	97	480	2	20	3.125
	98	485	2	15	2.81875
	99	490	2	10	2.6
	100	495	2	5	2.46875
	101	500	2	0	2.425
					2.425
Velocity - Position Graph
Velocity - Position	0	5	10	15	20	25	30	35	40	45	50	55	60	65	70	75	80	85	90	95	100	105	110	115	120	125	130	135	140	145	150	155	160	165	170	175	180	185	190	195	200	205	210	215	220	225	230	235	240	245	250	255	260	265	270	275	280	285	290	295	300	305	310	315	320	325	330	335	340	345	350	355	360	365	370	375	380	385	390	395	400	405	410	415	420	425	430	435	440	445	450	455	460	465	470	475	480	485	490	495	500	2.4249999999999998	2.46875	2.5999999999999996	2.8187499999999996	3.125	3.5187499999999998	4	4.5187499999999998	5.0249999999999995	5.5187499999999998	6	6.46875	6.9249999999999989	7.3687500000000004	7.8000000000000007	8.21875	8.625	9.0187499999999989	9.3999999999999986	9.7687500000000007	10.125	10.46875	10.799999999999999	11.118749999999999	11.424999999999999	11.71875	12.000000000000002	12.268749999999999	12.525	12.

Lab #1 – Problem Solving With Microsoft Excel -Cable Car Velocity Objective: In this lab you will learn and apply a five-step problem-solving process, use Microsoft Excel and learn its basic...

Answer To: Lab #1 – Problem Solving With Microsoft Excel -Cable Car Velocity Objective: In this lab you will...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment