Question

In: Statistics and Probability

A group students collected data on the speed of vehicles traveling through a construction zone on...

A group students collected data on the speed of vehicles traveling through a construction zone on a state highway, where the posted speed was 45 mph. The recorded speed (in mph) of 15 randomly selected vehicles is given below. You should be able to copy and paste them into Excel.

35

37

40

41

42

44

46

49

52

54

58

61

64

66

67

- Use Excel Data Analysis to find the mean, median, and mode of the data set. Make sure that you clearly state or point out which numbers are which. Don’t expect me to pick the numbers I want.

- Assuming speeds are approximately normally distributed, use Data Analysis to construct a 95% confidence interval for the true mean speed of drivers in this construction zone. Interpret the interval.

- Construct a 99% confidence interval for the true mean speed of drivers in this construction zone. Interpret the interval.

- Compare the widths of the 95% and 99% confidence intervals.

- What conclusions do you draw about the speeds people drive in this construction zone?

Solutions

Expert Solution

Discriptive Statistics
Mean 50.4
Standard Error 2.790801216
Median 49
Mode #N/A
Standard Deviation 10.80872663
Sample Variance 116.8285714
Kurtosis -1.349596941
Skewness 0.235636178
Range 32
Minimum 35
Maximum 67
Sum 756
Count 15
Confidence Level(95.0%) 5.985673297
Confidence Level(99.0%) 8.307776324

95% confidence interval is given by

99% confidence interval is given by

Compare the widths of 95% and 99% confidence intervals.

Range of 95% confidence interval = 71.58-29.21=42.37

Range of 99% confidence interval =78.246-22.55=55.69

What conclusions do you draw about the speeds people drive in this construction zone?

The conclusion is that the average speed is not 45 mph


Related Solutions

A group students collected data on the speed of vehicles traveling through a construction zone on...
A group students collected data on the speed of vehicles traveling through a construction zone on a state highway, where the posted speed was 45 mph. The recorded speed (in mph) of 15 randomly selected vehicles is given below. 35 37 40 41 42 44 46 49 52 54 58 61 64 66 67 1. Use Excel Data Analysis to find the mean, median, and mode of the data set. Make sure that you clearly state or point out which...
A group of Brigham Young University- Idaho Students collected data of the speed of vehicles traveling...
A group of Brigham Young University- Idaho Students collected data of the speed of vehicles traveling through a construction zone on a state highway, where the posted construction speed limit was 25 mph. The recorded speed for 14 randomly selected vehicles is given below. 20, 24, 27, 28, 29, 30, 32, 33, 34, 36, 38, 39, 40, 40 a. determine the sample standard deviation of the speeds b. comment on the appropriateness of using the Empirical Rule to make any...
Problem 2: Speeding in a construction zone A group of Brigham Young University—Idaho students collected data...
Problem 2: Speeding in a construction zone A group of Brigham Young University—Idaho students collected data on the speed of vehicles traveling through a construction zone on a state highway, where the speed was 25 mph. The recorded speed (in mph) of 14 randomly selected vehicles is given below: 20,24,27,28,29,30,32,33,34,36,38,39,40,40 Assuming speeds are approximately normally distributed, construct a 95% confidence interval for the true mean speed of drivers in this construction zone. Interpret the interval. Construct a 99% confidence interval...
The speed of 14 randomly selected vehicles passing through a construction zone is given: 20 24...
The speed of 14 randomly selected vehicles passing through a construction zone is given: 20 24 27 28 29 30 32 33 34 36 38 39 40 40 (a) Use Excel to find the five-number summary for the observed speeds • On your worksheet, add a new column anywhere with the data. • Click the Insert Function fx button in the Formula Bar • Select the category Statistical in the Insert Function dialog box 3 • In the Select a...
Residents are concerned about the speed of vehicles traveling on that road. Drivers seem to have...
Residents are concerned about the speed of vehicles traveling on that road. Drivers seem to have a tendency to drive at high speeds on their way out of and into town, even though the speed limit is only 25 mph. Police officers often record the speeds of the vehicles and ticket those who are found to be speeding.  the speeds from a sample of 33 vehicles recorded throughout one weekday : 24 25 26 27 27 27 28 28 28 29...
A recent survey in Spain revealed that 60% of the vehicles traveling on highways, where speed...
A recent survey in Spain revealed that 60% of the vehicles traveling on highways, where speed limits are posted at 120 km per hour, were exceeding the limit. Suppose you randomly record the speeds of ten vehicles traveling on 311 where the speed limit is 120 km per hour. Let X denote the number of vehicles that were exceeding the limit. a. What is the distribution of X? b. Find P(X = 10). c. Find the probability that the number...
Matlab question The data you will analyse is distribution zone substation data collected for the financial...
Matlab question The data you will analyse is distribution zone substation data collected for the financial years 2005 to 2017. It is available at https://cloudstor.aarnet.edu.au/plus/s/3Ffy7Qq3ps3i3vj with password ELEC2103#Assignment. 1. Write a sub-routine to load some or all of the Ausgrid distribution zone substation data into a useable format in MATLAB. 2. Write a sub-routine to analyse the data in MATLAB by modelling/fitting it, using regression, classification, ANOVA or other machine learning methods. You may wish to pre-process the data in...
The speeds of 80 vehicles were collected from a roadway section to estimate the mean speed....
The speeds of 80 vehicles were collected from a roadway section to estimate the mean speed. The margin of error for this sample mean was reported as 4 km/h at the confidence level of 90%. What is the sample size required to reduce this margin of error to 2 km/h (i.e., to ensure that the true mean is within ±2km/h of the sample mean 90% of the time)?
Problem 2: Speeding in a construction zone Please type the answer. Thank you. A group of...
Problem 2: Speeding in a construction zone Please type the answer. Thank you. A group of Brigham Young University—Idaho students collected data on the speed of vehicles traveling through a construction zone on a state highway, where the speed was 25 mph. The recorded speed (in mph) of 14 randomly selected vehicles is given below: 20,24,27,28,29,30,32,33,34,36,38,39,40,40 Assuming speeds are approximately normally distributed, construct a 95% confidence interval for the true mean speed of drivers in this construction zone. Interpret the...
Audience profit data collected at the ESPN sports zone web site showed that 26% of the...
Audience profit data collected at the ESPN sports zone web site showed that 26% of the users were women. Assume that this percentage was based on a sample of 400 users What would be the 99% confidence interval estimate of the population proportion? would you please do it step by step thanks
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT