Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need this answer using excel Some studies have shown that in the United States, men spend more than women buying gifts and cards on

I need this answer using excel

Some studies have shown that in the United States, men spend more than women buying

gifts and cards on Valentine's Day. Suppose a researcher wants to test this hypothesis by

randomly sampling nine men and 10 women with comparable demographic

characteristics from various large cities across the United States to be in a study. Each

study participant is asked to keep a log beginning one month before Valentine's Day and

record all purchases made for Valentine's Day during that one-month period. The

resulting data are shown below. Use these data and a 1% level of significance to test to

determine if, on average, men actually do spend significantly more than women on

Valentine's Day. Assume that such spending is normally distributed in the population and

that the

population variances are equal

.

Men

Women

$107.48

$125.98

143.61

45.53

90.19

56.35

125.53

80.62

70.79

46.37

83.00

44.34

129.63

75.21

154.22

68.48

93.80

85.84

126.11

aDecision is:

b)test t =

c)p-value for this test is =

d)Critical t value(s) is/are

e)Copy and paste a little distribution diagram and label the critical t value(s)

f)Copy and paste a little distribution diagram and label the tail boundaries bounding the p-value

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Introduction to the Mathematics of Financial Derivatives

Authors: Ali Hirsa, Salih N. Neftci

3rd edition

012384682X, 978-0123846822

More Books

Students also viewed these Mathematics questions

Question

=+What does this imply about antitrust laws?

Answered: 1 week ago