Question: Please answer as soon as possible, if you can show how to answer this on excel it would be great thank you. QUESTION 2 (20
Please answer as soon as possible, if you can show how to answer this on excel it would be great thank you.
QUESTION 2 (20 marks)
Is there evidence that the population mean price of the used cars at auction is equal to $13,000 at the 0.09 level of significance
FIND THE CONFIDENCE INTERVAL for your estimate.
Prices of cars at auction
| 6120 |
| 11570 |
| 13550 |
| 10305 |
| 14495 |
| 13050 |
| 13300 |
| 13135 |
| 12090 |
| 15480 |
| 14300 |
| 14250 |
| 11320 |
| 16040 |
| 8435 |
| 15590 |
| 9465 |
| 13925 |
| 18000 |
| 19310 |
| 7650 |
| 17850 |
| 9010 |
| 14940 |
| 14920 |
| 13420 |
| 12825 |
| 14700 |
| 15500 |
| 14615 |
| 8520 |
| 8430 |
| 14320 |
| 13890 |
| 14100 |
| 13790 |
| 14710 |
| 11305 |
| 11880 |
| 14250 |
| 16600 |
| 18470 |
| 17780 |
| 10765 |
| 12400 |
| 15445 |
| 12900 |
| 12950 |
| 11900 |
| 11940 |
| 14080 |
| 13680 |
| 13630 |
| 10520 |
| 14100 |
| 9090 |
| 15680 |
| 24830 |
| 10550 |
| 10825 |
| 14150 |
| 14375 |
| 17235 |
| 13030 |
| 12185 |
| 9830 |
| 10900 |
| 12215 |
| 11810 |
| 12760 |
| 14000 |
| 12170 |
| 15700 |
| 13445 |
| 16870 |
| 17030 |
| 12120 |
| 10820 |
| 17630 |
| 14970 |
| 16840 |
| 12820 |
| 12760 |
| 11405 |
| 9050 |
| 12925 |
| 14500 |
| 17140 |
| 16030 |
| 12200 |
| 14300 |
| 18450 |
| 6085 |
| 15450 |
| 8620 |
| 13035 |
| 8900 |
| 12980 |
| 6990 |
| 11750 |
| 13250 |
| 9150 |
| 8410 |
| 15460 |
| 14530 |
| 16825 |
| 6200 |
| 13480 |
| 13580 |
| 13300 |
| 15510 |
| 12450 |
| 12380 |
| 13500 |
| 18085 |
| 12900 |
| 9580 |
| 18200 |
| 9180 |
| 12630 |
| 15850 |
| 16450 |
| 5640 |
| 10500 |
| 14060 |
| 15990 |
| 8190 |
| 23930 |
| 8870 |
| 14630 |
| 9060 |
| 8510 |
| 15030 |
| 16955 |
| 15550 |
| 12420 |
| 12550 |
| 13700 |
| 12800 |
| 18530 |
| 13685 |
| 8850 |
| 11250 |
| 13670 |
| 17235 |
| 13560 |
| 16480 |
| 8080 |
| 15735 |
| 14180 |
| 16095 |
| 10200 |
| 12900 |
| 13580 |
| 9340 |
| 13280 |
| 17960 |
| 21085 |
| 14455 |
| 13885 |
| 17350 |
| 11000 |
| 12900 |
| 16300 |
| 12180 |
| 17010 |
| 15700 |
| 11310 |
| 13180 |
| 13200 |
| 7840 |
| 13980 |
| 13820 |
| 19615 |
| 14195 |
| 11810 |
| 16100 |
| 14400 |
| 14185 |
| 9310 |
| 14185 |
| 13750 |
| 15050 |
| 13150 |
| 7850 |
| 10995 |
| 16680 |
| 18035 |
| 18160 |
| 14860 |
| 16050 |
| 17815 |
| 14305 |
| 13340 |
| 7400 |
| 15350 |
| 14735 |
| 15000 |
| 15800 |
| 8445 |
| 13880 |
| 9490 |
| 16965 |
| 11690 |
| 17170 |
| 12735 |
| 14880 |
| 9215 |
| 8530 |
| 13350 |
| 7930 |
| 14560 |
| 12900 |
| 13000 |
| 12850 |
| 12930 |
| 16430 |
| 14340 |
| 15910 |
| 14060 |
| 14115 |
| 17400 |
| 17665 |
| 10390 |
| 12465 |
| 15660 |
| 10345 |
| 8480 |
| 13030 |
| 11815 |
| 7660 |
| 10140 |
| 14325 |
| 17935 |
| 17850 |
| 16995 |
| 17510 |
| 13220 |
| 12900 |
| 14350 |
| 13480 |
| 13400 |
| 14700 |
| 12695 |
| 13250 |
| 13550 |
| 13360 |
| 10180 |
| 10860 |
| 14780 |
| 9320 |
| 11900 |
| 13935 |
| 13130 |
| 12980 |
| 11295 |
| 14685 |
| 15100 |
| 17450 |
| 7655 |
| 13850 |
| 17390 |
| 16035 |
| 14410 |
| 9135 |
| 15735 |
| 13850 |
| 13085 |
| 15985 |
| 15535 |
| 12620 |
| 16800 |
| 14040 |
| 10990 |
| 13855 |
| 16165 |
| 12300 |
| 13730 |
| 15500 |
| 13700 |
| 14150 |
| 15135 |
| 16985 |
| 9830 |
| 13940 |
| 16350 |
| 15815 |
| 16600 |
| 10930 |
| 11950 |
| 12460 |
| 12120 |
| 14685 |
| 15700 |
| 15780 |
| 13200 |
| 17715 |
| 12360 |
| 15150 |
| 13350 |
| 16550 |
| 15695 |
| 15100 |
| 10285 |
| 14800 |
| 11620 |
| 9775 |
| 18410 |
| 11635 |
| 11970 |
| 14905 |
| 14300 |
| 17185 |
| 17455 |
| 15235 |
| 10380 |
| 13630 |
| 15650 |
| 17650 |
| 12500 |
| 13065 |
| 17760 |
| 10235 |
| 11985 |
| 13585 |
| 13900 |
| 15870 |
| 13905 |
| 17600 |
| 13950 |
| 15050 |
| 14135 |
| 15745 |
| 12800 |
| 14365 |
| 13385 |
| 18145 |
| 14420 |
| 12885 |
| 17160 |
| 13380 |
| 8040 |
| 8135 |
| 14435 |
| 19630 |
| 13485 |
| 12785 |
| 14935 |
| 13520 |
| 10790 |
| 14935 |
| 15405 |
| 9560 |
| 12665 |
| 12180 |
| 17805 |
| 15850 |
| 14660 |
| 15850 |
| 12750 |
| 15950 |
| 13010 |
| 16780 |
| 8930 |
| 13030 |
| 14785 |
| 23050 |
| 18035 |
| 12650 |
| 10635 |
| 13300 |
| 13705 |
| 15065 |
| 16680 |
| 13050 |
| 10670 |
| 16190 |
| 16280 |
| 17500 |
| 16660 |
| 12990 |
| 15680 |
| 13200 |
| 9995 |
| 13490 |
| 12160 |
| 13410 |
| 16415 |
| 12370 |
| 13565 |
| 11845 |
| 14710 |
| 14335 |
| 11600 |
| 14430 |
| 12390 |
| 8760 |
| 9725 |
| 14130 |
| 7195 |
| 13080 |
| 16230 |
| 10040 |
| 13030 |
| 14000 |
| 11550 |
| 18015 |
| 16820 |
| 15450 |
| 11600 |
| 15300 |
| 17850 |
| 8540 |
| 17035 |
| 17640 |
| 17630 |
| 17980 |
| 14390 |
| 14980 |
| 15185 |
| 14780 |
| 15550 |
| 12745 |
| 15260 |
| 11650 |
| 13985 |
| 13510 |
| 13125 |
| 14350 |
| 13170 |
| 7185 |
| 12780 |
| 16160 |
| 6920 |
| 12280 |
| 13000 |
| 13750 |
| 16535 |
| 15840 |
| 15115 |
| 14810 |
| 13890 |
| 16510 |
| 14350 |
| 16290 |
| 12370 |
| 19300 |
| 13470 |
| 15540 |
| 11310 |
| 14395 |
| 12595 |
| 14500 |
| 13030 |
| 13210 |
| 16035 |
| 7790 |
| 17935 |
| 14100 |
| 13700 |
| 17115 |
| 14140 |
| 16350 |
| 14680 |
| 16210 |
| 14170 |
| 11185 |
| 5240 |
| 13850 |
| 13880 |
| 8360 |
| 14635 |
| 13250 |
| 16850 |
| 18865 |
| 14150 |
| 15485 |
| 13450 |
| 11200 |
| 16700 |
| 15285 |
| 11535 |
| 14730 |
| 12070 |
| 14330 |
| 18020 |
| 15795 |
| 7400 |
| 16235 |
| 8410 |
| 7590 |
| 13200 |
| 17420 |
| 17530 |
| 7040 |
| 13515 |
| 14085 |
| 15130 |
| 15580 |
| 17850 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help