Question

Please explain what the t-test results determine below: are the new customers growing faster than the old? Are the new customers spending less or more than the old customers?

New Customer | Old Customer | |

Mean | 265.9284611 | 204.5386019 |

Variance | 14221.64096 | 13546.62069 |

Observations | 5569 | 4549 |

Pooled Variance | 13918.16209 | |

Hypothesized Mean Difference | 0 | |

df | 10116 | |

t Stat | 26.0378387 | |

P(T<=t) one-tail | 5.0467E-145 | |

t Critical one-tail | 1.64500427 | |

P(T<=t) two-tail | 1.0093E-144 | |

t Critical two-tail | 1.960198519 |

Answer #1

Two sample t test for equal variance test:

(Spending more or less)

The degree of freedom= 10116

Pooled variance= 13918.16209

t test value= 26.0378387

P-value(two tail)= 0.0000

The test statistic is significant and rejects H0. There is sufficient evidence to support that the new customers and old customer sample means are statistically different.

The test statistic value is positive. so, we can conlude that the new customers are spending more money than old customers.

t-Test: Two-Sample Assuming Equal Variances
Eagles Age
Patriots Age
Mean
27.76662516
28.15171678
Variance
12.09082453
12.65872713
Observations
77
77
Pooled
Variance
12.37477583
Hypothesized Mean Difference
0
df
152
t
Stat
-0.679243926
P(T<=t) one-tail
0.249008166
t
Critical one-tail
1.654940175
P(T<=t) two-tail
0.498016332
t
Critical two-tail
1.975693928
What can I concluded by this?

t-Test: Two-Sample Assuming Equal Variances
Eagles Height in inches
Patriots Height in inches
Mean
73.51948052
73.94805195
Variance
7.095010253
7.786739576
Observations
77
77
Pooled
Variance
7.440874915
Hypothesized Mean Difference
0
df
152
t
Stat
-0.974858488
P(T<=t) one-tail
0.165589676
t
Critical one-tail
1.654940175
P(T<=t) two-tail
0.331179353
t
Critical two-tail
1.975693928
What can I conclude by this?

t-Test: Two-Sample Assuming Equal Variances
Eagles Weight
Patriots Weight
Mean
238.6623377
246.7012987
Variance
2206.647642
2141.501709
Observations
77
77
Pooled
Variance
2174.074675
Hypothesized Mean Difference
0
df
152
t
Stat
-1.069776516
P(T<=t) one-tail
0.143207882
t
Critical one-tail
1.654940175
P(T<=t) two-tail
0.286415763
t
Critical two-tail
1.975693928
Conclusion of this t-test? What can I concluded by this?

Conduct an independent sample t-test (alpha= .05) in Excel to
determine whether there is a significant difference in the age of
offenders at prison admissions between White and Black offenders.
For this t-test, assume that the variances of the two groups are
equal. In your summary, please discuss the null hypothesis,
alternative hypothesis, the result of this hypothesis test, and
interpret the result.
t-Test: Two-Sample Assuming Equal Variances
White
Black
Mean
235.5714286
199.164557
Variance
44025.35714
87049.21616
Observations
21
79
Pooled...

Please interpret the output below. What type of test was used
and why? Are energy costs lower for LEED-certified buildings in
this output? These data have an effect size of d = .39. How does
that add to your interpretation of the results?
Yearly Energy Costs LEED- Certified Buildings
(in thousands of $)
Yearly Energy Costs non-LEED- Certified Buildings
(in thousands of $)
Mean
18.22
21.46
Variance
1548.27
1318.33
Observations
60
55
Hypothesized Mean Difference
0
df
73
t Stat...

Are prices for oranges in Florida higher than prices for Texas
oranges based on the data, test this hypothesis.
TEXAS
FLORIDA
Mean
7.762
6.738
Variance
15.50461714
6.737874286
Observations
15
15
Hypothesized Mean Difference
0
df
24
t
Stat
0.840918429
P(T<=t) one-tail
0.204347052
t
Critical one-tail
1.71088208
P(T<=t) two-tail
0.408694103
t
Critical two-tail
2.063898562

A researcher is interested in whether salaries for middle school
teachers were less than salaries for nurses in Arkansas. A
statewide salary survey is conducted using random sampling.
The Data Analysis output for the various tests used when
comparing two group means are shown below. The significance level
was .05.
F-Test Two-Sample for Variances
Teachers
Nurses
Mean
45946.07
53365.13
Variance
68256753
86820446
Observations
300
300
df
299
299
F
0.7862
P(F<=f) one-tail
0.0190
F Critical one-tail
0.8265
t-Test: Paired Two...

Use the following to answer the next question. Do government
employees take longer coffee breaks than private sector workers?
That is a question that interested a management consultant. To
examine the issue, he took a random sample of ten government
employees and another random sample of ten private sector workers
and measured the amount of time (in minutes) they spent in coffee
breaks during the day (the samples are assumed to be
independent).
PS: Relevant outputs are given below; please...

Use the following to answer the next 2 questions. Do government
employees take longer coffee breaks than private sector workers?
That is a question that interested a management consultant. To
examine the issue, he took a random sample of ten government
employees and another random sample of ten private sector workers
and measured the amount of time (in minutes) they spent in coffee
breaks during the day (the samples are assumed to be
independent).
PS: Relevant outputs are given below;...

Ace is a major manufacturer of golf equipment. Ace is developing
a new more durable golf ball. The researchers are concerned that
the changes made have significantly reduced the driving distance of
the new ball. They perform an experiment comparing the new golf
ball to the current model. The results of the study are
below.
t-Test: Two Sample Assuming
Unequal Variances
Current
New
Mean
270.28
267.50
Variance
76.61
97.95
Observations
40
40
Hypothesized Mean Difference
0
df
77
t Stat...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 7 minutes ago

asked 33 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago