ZuoTi.Pro
Question

I need this solved on Excel please

4. The following data were collected on speeds on H1, a major highway. Using Excels statistical functions, complete the following questions. 90 75 57 64 68 60 82 67 SPEED (MPH) 78 57 71 52 65 63 69 61 a. What is the mean of the data set for speed on H1? b. What is the standard deviation of the data set for speed on H1? c. Construct a histogram for the speed data set using 5 mph as your class width starting with 50 as your lowest class.

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Answei Date: 08/02/2018 a) The mean of speed on H1 is, By using Excel software, find mean with the help of following steps 1)b) The standard deviation ofspeed on H1 is From the Excel output in part (a), the standard deviation ofspeed on H is 10.21 c)Histogram 25 20 . 10 Speed

0 0
Add a comment
Know the answer?
Add Answer to:
I need this solved on Excel please 4. The following data were collected on speeds on...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Use the accompanying data set on the pulse rates​ (in beats per​ minute) of males to...

    Use the accompanying data set on the pulse rates​ (in beats per​ minute) of males to complete parts​ (a) and​ (b) below. LOADING... Click the icon to view the pulse rates of males. a. Find the mean and standard​ deviation, and verify that the pulse rates have a distribution that is roughly normal. The mean of the pulse rates is 71.871.8 beats per minute. ​(Round to one decimal place as​ needed.) The standard deviation of the pulse rates is 12.212.2...

  • Consider the below matrixA, which you can copy and paste directly into Matlab.

    Problem #1: Consider the below matrix A, which you can copy and paste directly into Matlab. The matrix contains 3 columns. The first column consists of Test #1 marks, the second column is Test # 2 marks, and the third column is final exam marks for a large linear algebra course. Each row represents a particular student.A = [36 45 75 81 59 73 77 73 73 65 72 78 65 55 83 73 57 78 84 31 60 83...

  • estimate the average age at which multiple sclerosis patients were diagnosed with the condition for the...

    estimate the average age at which multiple sclerosis patients were diagnosed with the condition for the first time in a given city. How big should the sample be? Define your procedures for this estimate (if necessary, set your own values of unknown parameters, based on statistical theory). In Table 1 you will find all ages of this patient population. 54 58 56 48 62 59 55 56 60 52 53 61 56 56 53 37 71 62 39 61 54...

  • The following data give the speeds (in miles per hour) of 12 cars traveling on a...

    The following data give the speeds (in miles per hour) of 12 cars traveling on a highway. 67 71 57 54 69 74 77 62 61 59 58 63 a. Calculate the values of three quartiles. b. Find the (approximate) value of the 40th percentile. c. Find the percentile rank of 62

  • Provided set of data are concentrations of suspended solids in river water that are collected for...

    Provided set of data are concentrations of suspended solids in river water that are collected for environmental characteristics. Total of 36 samples have concentrations of: 84 49 61 40 83 67 45 66 70 69 80 58 68 60 67 72 73 70 57 63 70 78 52 67 53 67 75 61 70 81 76 79 75 76 58 31 a) Construct a stem‐and‐leaf display of the data. b) Calculate first and third quartiles and median from stem‐and‐leaf display...

  • Please answer all questions! thanks :) VI/ Test scores from a math midterm are as follows:...

    Please answer all questions! thanks :) VI/ Test scores from a math midterm are as follows: 79, 90, 85, 89, 70, 59, 75, 64, 83, 78, 75, 77, 78, 77, 67, 85, 74, 52, 87, 72, 69, 76, 61, 77, 93, 86, 79, 90, 74, 67, 51, 75, 77, 82, 78, 60, 86, 72, 91, 95, 82 Complete the frequency distribution table to include all data a. Class Tallies Class Midpoint Relative Cumulative Frequency relative freq boundaries Frequency 51 57...

  • The Thompson Tire Company did research in Alabama regarding the miles their commercial truck tires would...

    The Thompson Tire Company did research in Alabama regarding the miles their commercial truck tires would travel before they no longer met the Federal Highway Department tread depth requirements. The results of their study are in the file “Thompson Data Spring 2019” and show the mileage in 1,000 miles. Calculate the mean, median and mode of the data. Develop a box plot. Are there any outliers? Do the amounts follow a symmetric distribution or are they skewed? Justify your answer....

  • 1. Forecast demand for Year 4. a. Explain what technique you utilized to forecast your demand....

    1. Forecast demand for Year 4. a. Explain what technique you utilized to forecast your demand. b. Explain why you chose this technique over others. Year 3 Year 1 Year 2 Actual Actual Actual Forecast Forecast Forecast Demand Demand Demand Week 1 52 57 63 55 66 77 Week 2 49 58 68 69 75 65 Week 3 47 50 58 65 80 74 Week 4 60 53 58 55 78 67 57 Week 5 49 57 64 76 77...

  • The following data give the speeds (in miles per hour) of 12 cars traveling on a...

    The following data give the speeds (in miles per hour) of 12 cars traveling on a highway. 67 71 57 54 69 74 77 62 61 59 58 63 a. Calculate the values of three quartiles. (3 points) b. Find the (approximate) value of the 40th percentile. (2 points) c. Find the percentile rank of 62: (3 points)

  • The following table presents the daily high temperatures for the city of Macon, Georgia, in degrees...

    The following table presents the daily high temperatures for the city of Macon, Georgia, in degrees Farenheit, for the winter months of January and February in a recent year. If there are no leaves, enter "N." 67 58 56 74 56 58 65 63 77 53 73 57 51 56 48 68 51 66 64 53 78 61 55 69 56 63 61 71 51 66 67 58 63 52 75 52 60 70 71 62 58 52 61 65...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT