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...

1 answer below »
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.
Answered Same DayJun 22, 2021

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

Hanumantha Rao answered on Jun 23 2021
145 Votes
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 conta
ins 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 -...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here