Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Knowing all the information from dataset, what is the right answer to the Question 3 [03]? Sample Standard Deviation 12 Sample Mean 15.1 Sample Size
Knowing all the information from dataset, what is the right answer to the Question 3 [03]? Sample Standard Deviation 12 Sample Mean 15.1 Sample Size 2? Confidence Level 95% Standard Error of the Mean 01 Degrees of Freedom 02 t Value Interval Half Width 03 Interval Lower Limit 04 Interval Upper Limit 05 Hint: Excel results are shown the table below: 11012100525] 2.05552044 110010.05, 25} 005331402 1114121005221 205153052 111413100527} 00532023 5051921 510515242 305195} 5.00001051 2215001127] 133554055 2215001125) 1.4120351? 151130011271 2.00500535 15113001125] 055075023 Note that you have to write all digits that appear in Excel until hundered-thousandth's. For example, 2.44445 has "five digits after decimal point\". You may need to round up. Knowing all the information from dataset, what is the right answer to the Question 2 (Q2)? Sample Standard Deviation 7.2 Sample Mean 15.1 Sample Size 27 Confidence Level 95% Standard Error of the Mean Q1 Degrees of Freedom Q2 t Value Interval Half Width Q3 Interval Lower Limit Q4 Interval Upper Limit Q5 Hint: Excel results are shown the table below: TINV (0.05,26) 2.05552944 TINV (0.95, 26) 0.06331492 TINV (0.05,27) 2.05183052 TINV (0.95,27) 0.0632923 SQRT(27) 5.19615242 SQRT (26) 5.09901951 7.2/SQRT(27) 1.38564065 7.2/SQRT (26) 1.41203617 15.1/SQRT(27) 2.90599635 15.1/SQRT(26) 0.58076923In determining automobile mileage ratings, it was found that the mpg [X J for a certain model is normally distributed ( meaning cumulative distribution]' with a mean of 30 mpg and a standard deviation of 1.5 mpg. Find the following: PD: :- 2?} Excel Formula Result NORM.DIST[2?', 30.1.5.1] 002350132 NORMDISTIQZ 30.1.5.0} 0035093008 NORM.DIST[20,30,1.E,1] 009121122 NORM.DIST[28,30,1.5,0} 010934005 NORM.DIST[31,30,1.5,11 0347507452 NORM.DIST[31,30,1.5,0} 0.2129653 37' NORM.DIST[32,30,1.5,1] 0.QOS?B B?8 NORM.DIST[32,30,1.E,0} 010934005 NORM.DIST[33,30,1.5,1} 03?? 240363 NORM.DIST[33,30,1.E,0) 0.0359939?8 Note that you have to write all digits that appear in Excel until hundered-thousandth's. For example, 2.44445 has \"five digits after decimal point\". Answer: In determining automobile mileage ratings, it was found that the mpg [X J for a certain model is normally distributed i meaning cumulative distribution], with a mean of 30 mpg and a standard deviation of 1.5 mpg. Find the following: P{2? (X 32) Excel Formula Result NORM.DIST (27,30,1.5,1) 0.022750132 NORM.DIST (27,30,1.5,0) 0.035993978 NORM.DIST (28,30,1.5,1) 0.09121122 NORM.DIST (28,30,1.5,0) 0.10934005 NORM.DIST (31,30,1.5,1) 0.747507462 NORM.DIST (31,30,1.5,0) 0.212965337 NORM.DIST (32,30,1.5,1) 0.90878878 NORM.DIST (32,30,1.5,0) 0.10934005 NORM.DIST (33,30,1.5,1) 0.977249868 NORM.DIST (33,30,1.5,0) 0.035993978 Note that you have to write all digits that appear in Excel until hundered-thousandth's. For example, 2.44445 has five digits after decimal point. You may need to round up.Knowing all the information from dataset, what is the right answer to the Question 4 {34}? Sample Standard Deviation 12 Sample Mean 15.1 Sample Size 2? Confidence Level 95% Standard Error of the Mean 01 Degrees of Freed om (3)2 tValue Interval Half Width 03 Interval Lower Limit 04 Interval Upper Limit 05 Hint: Exoel results are shown the table below: 031.10.05.23} 205552344 031.1035, 23} 003331432 TINVIQ.05,2?] 2.05133052 0141.10.35.22} 0.0532323 3031(22} 513315242 303011251 503301351 ?.21'SQFIT[2?] 133534035 2.2,:333TI251 1.4120331? 15.1;soan271 230533335 15.1;soan251 053073323 Note that you have to write all digits that appear in Excel until hundered-thousandth's. For example, 2.44445 has five digits after decimal point. You may need to round up
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started