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...
Consider the below vector x, which you can copy and paste directly into Matlab. The vector...
Consider the below vector x, which you can copy and paste directly into Matlab. The vector contains the final grades for each student in a large linear algebra course. x = [61 52 63 58 66 92 64 55 76 60 70 78 76 73 45 63 97 70 100 76 50 64 42 100 67 81 81 59 68 62 72 99 66 76 81 59 47 84 67 75 63 86 73 44 51 69 48 74 61...
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...
have a java application need to create an application which is able to do some analysis...
have a java application need to create an application which is able to do some analysis on temperature data stored in a data file. You will be given the “temperatures.dat” data file which contains the data you must analyze. The analysis you’ll need to do is: Total number of data points Find coldest temperature Find warmest temperature Find average temperature Find the frequency of each temperature Find the most frequent temperature Find the least frequent temperature All classes must be...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT