Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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