1. Explain which hypothesis test would be appropriate for this situation
2. Complete a hypothesis test in excel to test your claim. Copy and paste your excel output below.
3. Write a conclusion statement that makes use of excel data to justify which hypothesis is supported and why.
4. State decision in context of the research question “Do all four regions have equal average weights?”
5. Create an Excel box plot of all 4 four regions side by side (like in STAT3001) and paste it here. Add a chart title and legend. Write a sentence or two on how this graph justifies your answer in question 4. Remember, these charts show the 5-number summary.
region 1
18.7
38.6
28.7
24.1
18.7
22.9
36.6
37.3
37.8
33.4
31.4
23.4
26.0
26.1
30.9
24.7
22.0
30.5
24.7
31.7
33.3
26.5
22.0
25.2
30.2
31.9
17.0
31.2
19.2
region 2
32.9
33.4
24.6
40.2
19.8
20.7
32.4
28.8
24.5
23.3
38.4
23.3
43.6
32.7
28.8
35.0
25.6
24.8
17.9
30.8
24.7
24.5
25.2
26.1
27.6
25.5
22.8
29.2
33.9
45.9
24.8
28.9
30.3
32.4
30.9
26.4
region 3
35.4
29.8
21.9
24.8
56.8
47.2
41.1
22.3
33.3
22.5
30.3
47.0
28.0
23.6
34.8
23.3
24.0
32.5
26.8
32.2
22.6
29.2
35.0
28.4
40.0
24.4
24.4
29.8
27.5
31.9
34.2
region 4
27.3
37.1
31.1
39.2
30.1
33.1
25.9
18.9
26.7
52.6
31.0
19.8
25.2
21.9
40.8
25.6
22.7
25.2
26.6
43.7
24.2
22.9
25.3
30.6
24.5
26.6
22.6
25.9
30.1
28.0
36.2
27.3
39.9
20.3
23.4
31.8
21.6
24.7
31.0