Question

Use Excel to find the following: Compare the height, weight (in inches), and age for Eagles...

Use Excel to find the following: Compare the height, weight (in inches), and age for Eagles versus Patriots, using t tests. Provide the conclusions based on the t tests.

Gaps between numbers under age are no value

77 each

Eagles:

Age
35
28
23
23
29
23
24
31
28
24
24
24
26
31
23
26
25
25
31
29
33
30
22
28
23
24
29
23
24
26
32
26
24
23
29
24
23
30
24
26
38
26
24
25
27
25
26
22
26
30
25
28
30
33
28
25
29
25
33
27
25
36
24
24
26
31
29
27
25
27
33
29
28
24

25

-------------------

Height (")
66   
69   
69   
69   
69   
69   
70   
70   
70   
70   
70   
71   
71   
71   
71   
71   
71   
72   
72   
72   
72   
72   
72   
72   
72   
72   
72   
72   
72   
72   
73   
73   
73   
73   
73   
74   
74   
74   
74   
74   
74   
74   
74   
74   
74   
74   
74   
75   
75   
75   
75   
75   
75   
75   
75   
75   
75   
75   
76   
76   
76   
76   
76   
76   
76   
76   
77   
77   
77   
77   
77   
77   
78   
78   
78   
78   

78   

--------------

Pats

Age
28
28
32
26
28
31
28
41
33
30
24
28
24
28
30
26
31
25
24
24
30
25
29
32
25
29
26
26
25
24
27
28
34
26
26
29
28
27
34
40
28
29
24
24
32
31
24
24
24
25
25
24
25
24
26
24
28
24
25
25
31
26
25
24
24
25
33
30
25
24
26
24
27
27
26
23

24

Height (")
75
74
71
75
72
78
71
76
78
75
74
70
76
71
78
75
71
70
77
75
75
70
72
70
76
74
78
75
74
79
71
73
73
74
76
78
76
73
74
72
75
73
76
76
74
75
78
70
75
70
76
77
74
76
74
75
68
72
73
69
70
68
71
77
72
73
72
80
77
74
74
75
75
78
70
70
77
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

There are 2 missing values in age for eagles , i have replaced them with 25

Please see the excel screenshots below

we will consider an alpha of 0.05

so we see that the p value of t test is 0.523

as the p value is not less than 0.05 , we fail to conclude that there is a significant difference between the mean values of age for eagles and patriots

Similarly we conduct analysis for height as

we will consider an alpha of 0.05

so we see that the p value of t test is 0.3311

as the p value is not less than 0.05 , we fail to conclude that there is a significant difference between the mean values of height for eagles and patriots

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Data Set Height Weight Age Shoe Size Waist Size Pocket Change 64 180 39 7 36...
Data Set Height Weight Age Shoe Size Waist Size Pocket Change 64 180 39 7 36 18 66 140 31 9 30 125 69 130 31 9 25 151 63 125 36 7 25 11 68 155 24 8 31 151 62 129 42 6 32 214 63 173 30 8 34 138 60 102 26 6 25 67 66 180 33 8 30 285 66 130 31 9 30 50 63 125 32 8 26 32 68 145 33...
The heights (in inches) and weights (in pounds) of 25 baseball players are given below. Use...
The heights (in inches) and weights (in pounds) of 25 baseball players are given below. Use Excel to find the best fit linear regression equation, where height is the explanatory variable. Round the slope and intercept to two decimal places. Height   Weight 71   186 72   211 73   220 70   165 72   180 72   195 70   175 74   202 78   240 71   170 74   180 73   185 76   257 77   215 76   287 77   220 73   200 76   223 76   200...
3. (a) Use the sample to make a point estimate of the mean height of the...
3. (a) Use the sample to make a point estimate of the mean height of the entire female/male SCC student body. (b) Construct a 93% confidence interval for the mean height of the entire female/male SCC student body. (c) What is the width of this interval? (d) Write a sentence interpreting your confidence interval. male Student # Gender Height Shoe Age Hand 1 M 67 10 19 R 2 M 74 12 17 R 3 M 72 11.5 19 R...
Mid Score Final Score 80 78 87 85 72 81 69 54 86 70 83 73...
Mid Score Final Score 80 78 87 85 72 81 69 54 86 70 83 73 78 89 75 84 74 86 75 79 84 75 73 63 74 72 73 69 80 86 75 78 72 75 77 68 76 77 66 78 74 77 71 73 85 79 74 74 76 79 76 73 84 72 77 81 78 86 86 76 81 83 78 83 85 86 73 71 83 83 83 79 72 68 83 90...
Student Grades Student Test Grade 1 76 62 2 84 90 3 79 68 4 88...
Student Grades Student Test Grade 1 76 62 2 84 90 3 79 68 4 88 84 5 76 58 6 66 79 7 75 73 8 94 93 9 66 65 10 92 86 11 80 53 12 87 83 13 86 49 14 63 72 15 92 87 16 75 89 17 69 81 18 92 94 19 79 78 20 60 71 21 68 84 22 71 74 23 61 74 24 68 54 25 76 97...
StudentNO Gender Height in inchese 1 Female 63 2 Female 64.0 3 Male 67.0 4 Female...
StudentNO Gender Height in inchese 1 Female 63 2 Female 64.0 3 Male 67.0 4 Female 59 5 Male 60 6 Female 61 7 Female 62 8 Female 63 9 Female 63 10 Female 64 11 Male 64 12 Female 65 13 Female 65 14 Female 65 15 Female 65 16 Female 66 17 Female 66 18 Male 67 19 Male 67 20 Male 67 21 Female 67 22 Male 67 23 Male 67 24 Female 67.5 25 Male 68...
Use ? to approximate σ. Use a 5% level of significance. Data: 69 62 75 66...
Use ? to approximate σ. Use a 5% level of significance. Data: 69 62 75 66 68 57 61 84 61 77 62 71 68 69 79 76 87 78 73 89 81 73 64 65 73 69 57 79 78 80 79 81 73 74 84 83 82 85 86 77 72 79 59 64 65 82 64 70 83 89 69 73 84 76 79 81 80 74 77 66 68 77 79 78 77
Write the null and alternative hypothesis for a two-tailed test for each of the following variables:...
Write the null and alternative hypothesis for a two-tailed test for each of the following variables: (10 points) Student Ht Wt Age (Yrs) Shoe Size Waist Size Pocket Change 01 64 180 39 07 36 018 02 66 140 31 09 30 125 03 69 130 31 09 25 151 04 63 125 36 07 25 011 05 68 155 24 08 31 151 06 62 129 42 06 32 214 07 63 173 30 08 34 138 08 60...
Listed are 32 ages for Academy Award winning best actors in order from smallest to largest....
Listed are 32 ages for Academy Award winning best actors in order from smallest to largest. 18; 18; 21; 22; 25; 26; 27; 29; 30; 31; 31; 33; 36; 37; 38; 41; 42; 47; 52; 55; 57; 58; 62; 64; 67; 69; 71; 72; 73; 74; 76; 77 1. Find the percentile of 37. 2. Find the percentile of 72.
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades...
Using the accompanying Student Grades​ data, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the​ model? If a student scores 7878 on the​ midterm, what would you predict her grade on the final exam to​ be? Student Midterm Final Exam 1 75 64 2 85 91 3 80 68 4 88 83 5 76 60 6 67 80 7 78 74 8 95 94 9 67 61 10 93 87 11...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT