STEP BY STEP ANSWERS IN EXCEL FORMAT ONLY PLEASE! SHOW FORMULA! THANK YOU!
The present study shows data for direct flights from Orlando to Miami for one airline. The airline claims that the flying time (time in the air) of direct flights from Orlando to Miami takes 45 minutes. The company would like to test the claim and collects a random sample of 90 flights. We will find the average and standard deviation for the flights’ times for the random sample of flights. We will use Excel
Flight Duration (Time in the air) in minutes |
45.0 |
42.0 |
41.0 |
38.0 |
41.0 |
44.0 |
51.0 |
47.0 |
43.0 |
40.0 |
46.0 |
45.0 |
43.0 |
44.0 |
43.0 |
39.0 |
44.0 |
48.0 |
48.0 |
51.0 |
50.0 |
43.0 |
41.0 |
51.0 |
40.0 |
45.0 |
49.0 |
55.0 |
41.0 |
41.0 |
40.0 |
41.0 |
45.0 |
50.0 |
47.0 |
50.0 |
42.0 |
46.0 |
48.0 |
44.0 |
42.0 |
47.0 |
46.0 |
48.0 |
48.0 |
51.0 |
48.0 |
59.0 |
46.0 |
47.0 |
52.0 |
49.0 |
50.0 |
50.0 |
52.0 |
49.0 |
42.0 |
42.0 |
43.0 |
45.0 |
39.0 |
49.0 |
48.0 |
49.0 |
43.0 |
41.0 |
45.0 |
43.0 |
43.0 |
50.0 |
42.0 |
46.0 |
41.0 |
47.0 |
43.0 |
51.0 |
48.0 |
47.0 |
43.0 |
50.0 |
44.0 |
42.0 |
56.0 |
49.0 |
46.0 |
44.0 |
48.0 |
51.0 |
51.0 |
49.0 |
1) find the Standard Deviation of the flight time for the sample flights
2) identify the degrees of freedom needed to find the critical values?
3) find a one-sided critical value from the appropriate probability table to test the claim at alpha = 0.05 (hint: use the T.INV.2T function with the appropiate alpha level and degrees of freedom)
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 4 images
- Please box every answrarrow_forwardA California lake has been stocked with rainbow trout. These trout have an average length of 24 inches, with a standard deviation of 3 inches. Someone goes fishing and catches a trout that is 26.25 inches long. Express the length of this trout in standard units, relative to all the trout that were used to stock the lake. Choose the answer below that is closest.arrow_forwardYou will be comparing two sets of data for this assignment. 1. Determine the average number of toilet paper rolls* for Fall 2022 biochemistry and genetics students (individually) and calculate the standard deviation of each using the equation. Please be sure to show your work. I know that you can easily use tools like Microsoft Excel to calculate standard deviation, but I would like to see you complete the work by hand so that you get a sense of the role of each component of the equation. Ignore students that did not provide answers (don't use those students in the mean or N value calculations). 2. Please answer the following questions when you submit your data. Which group had a higher mean number of rolls of toilet paper? Which value had the most variability? Referring to the equation, how could you decrease the amount of variability in the mean? Did you find the variation surprising or unexpected? The two sets of data and the standard deviation formula pictures are attached…arrow_forward
- Determine the range, mean, and standard deviation of the data set. {9,5,9,17,17,16,3,8} Please note that I did submit this question earlier but was unable to recognize the answers so I would appreciate it if it the answers are written clearly. Thank youarrow_forwardWhat type of data would you use for collecting data on lap swim time?arrow_forwardPlease discuss the concepts of Mean, Median, Mode, and Standard Deviation, including when each should be used, and evaluate the differences of each. How can knowing this information about data help us?arrow_forward
- Suppose the correlation between height and weight for adults is +0.40.What proportion (or percent) of the variability in weight can be explained by the relationship with height?arrow_forwardExplain the t-test as it relates to its application to one samplesarrow_forwardFind the area of the shaded region. The graph to the right depicts IQ scores of adults, and those scores are normally distributed with a mean of 100 and a standard deviation of 15. The area of the shaded region is. (Round to four decimal places as needed.) om/Player/Player.aspx?cultureld=&theme=math&style=highered&disableStandbyIndicator=true&assignmentHandlesLocale=true# NO REF SAMPLE....pdf 2 W S 5373255.docx X H ommand # 3 80 F3 E D $ A 4 C Q F4 R F % 01 % 5 V T G < 6 MacBook Air B Y TEMPLATE Sel....docx & 7 H F7 N * 8 J A DII FB 1 M 9 resume..docx K O < H db O L F10 P Clear all command - Л. : ; I { + [ = 80 option Check answer ? Show All I } A 1 G X delearrow_forward
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman