I\'ve started the assignment but I\'m not sure if my current answers are correct

Question

I've started the assignment but I'm not sure if my current answers are correct. I can't upload my excel document but I shared a screenshot.

1. Calculate the average and standard deviation for PSI for both the New England and Colts data sets

Patriots mean PSI: Blakeman = 11.11, Prioleau = 11.46

Standard deviation of Patriots PSI: Blakeman = 0.40, Prioleau = 0.40

Colts mean PSI: B = 12.63, P = 12.44

Standard Deviation of Colts PSI: B = 0.12, P = 0.35

2. Calculate the standard error of the mean for both data sets

Standard error of the mean (Patriots PSI): Blakeman = 0.1213, Prioleau = 0.1196

Standard error of the mean (Colts PSI): B = 0.0595, P = 0.1760

3. Calculate a 95% Confidence Interval for each team's average psi

Lower CI (Pats) =

Upper CI (Pats) =

Lower CI (Colts) =

Upper CI (Colts) =

4. The NFL requires each team to inflate the balls to 13 psi +/- 0.5 psi. Do either the Pats or Colts CI's show that they meet this standard? Why, or why not do the data support/reject this requirement?

5. Does the data show, that when allowing for vaiablity in inflation of each ball, that the Pats and Colts balls were inflated to "approximately" the same psi (statistically insignificant differences)? Why/why not do you conclude there were differences?

6. Are there any statistically significant differences between the 2 officials sets of measurements for each team? Why/why not do you conclude there were differences?

______________________________________________________________________________

The New England Patriots football team and staff have made the news recently for allegedly deflating the football (reducing the internal air pressure in order to make it easier to grip and throw the football) when the Patriots were on the offense. The balls were allegedly inflated to the higher, league requirement (13 PSI +/- .5 lbs) when the opponents were on offense.

In the documents folder in MyStatLab (and on Canvas -week 8) there is a copy of the data collected from 15 footballs that were measured at half-time of this year's Patriots/Colts games. 11 of the footballs were from when the Patriots were on offense. 4 of the balls come from when the Colts were on offense.

Deflate gate Graphs Excel Sign in File Home insert Page Layout Formulas aa Review View Tel me what you want ta d 2 Cul Colibri 11-A A Copy Conditional Format Ccll Feematti Clear Sorn & Find Filter Select Farmat Pairter BI U ng- Table. Styles. Insert Delete Format ipbaan1 Alignment dring N28 cempare to NEL 95% 0-13 t/-S 1244 within th NF Olakemarn 12.63 16 nros 17 std cey ,563 0000 6.1636C00O 20 muiNFL 00122 22 1(95%'-1 tdata2.8 1055107 15,5858817-128313 241806E-48 15E-0 6.301263.1953 33 NFL 1.5-2.25 .563G3G3D .10304 95977E-14 3SSE-10 35 sample tast 36 s1-s1 0.092913 0.051371132 Ldal-6.81315498 Sheet Sheet2 Sheet3

Explanation / Answer

1) and 2)

Patriots

colts

1) and 2) are correct , but you may want to increase the rounding to 4 decimal instead of 2 decimal as you have done

3)

Patriot Blackman
Variable   N    Mean StDev SE Mean       95% CI
C1        11 11.109 0.402    0.121       (10.839, 11.379)

Prioleau

One-Sample T: C2

Variable   N    Mean StDev SE Mean       95% CI
C2        11 11.459 0.397    0.120 (11.193, 11.726)

Colts B

Variable N     Mean   StDev SE Mean        95% CI
C4        4 12.6250 0.1190   0.0595    (12.4356, 12.8144)

Colts P

Variable N    Mean StDev SE Mean       95% CI
C5        4 12.437 0.352    0.176      (11.877, 12.998)

Note that this is confidence interval of all 4 individual team, if you want to merge

Patriots
Variable   N     Mean   StDev SE Mean        95% CI
C1        22 11.2841 0.4291   0.0915 (11.0938, 11.4743)

Colts

Variable N     Mean   StDev SE Mean        95% CI
C4        8 12.5313 0.2631   0.0930     (12.3113, 12.7512)

t-Test: Two-Sample Assuming Equal Variances Variable 1 Variable 2 Mean 11.10909091 11.45909091 Variance 0.161909091 0.157409091 0.402379 0.396748 sd Observations 11 11 0.121322 0.119624 standard error Pooled Variance 0.159659091 Hypothesized Mean Difference 0 df 20 t Stat -2.054246535 P(T<=t) one-tail 0.026627514 t Critical one-tail 1.724718243 P(T<=t) two-tail 0.053255027 t Critical two-tail 2.085963447

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.