excel assignment help

q5.xlsx

Question 1

Quiz 5 Fall 2020 E270 Statistics

USA Today reports that the average expenditure on Valentine's day is $100.89. Do male and female

consumers differ in the amounts they spend? The average expenditure in a sample survey of 40 male

consumers was $135.67, and the average expenditure is a sample survey of 30 female consumers was

$68.64. Based on past surveys, the standard deviation for male consumers is assumed to be $35.00, and

the standard deviation for female consumers is assumed to be $20.

What is the point estimate between the population mean expenditure for males and the population

mean expenditure for females?

At a 99% confidence, what is the margin of error?

Develop a 99% confidence interval for the difference between the two population means.

Quiz 5 Fall 2020 E270 Statistics

Members of the millennial generation are continuing to be dependent on the parents (either

living with them or otherwise receiving support from parents) into early adulthood. A family

research organization has claimed that, in past generations, no more than 30% of individuals

18 to 32 continued to be dependent on their parents. Suppose that a sample of 400 individuals

aged 18 to 32 showed that 136 of them continued to be dependent on their parents.

Develop a hypothesis for a test to determine whether the proportion of millennials continuing to

be dependent on their parents is higher than in past generations.

What is your point estimate for the population of millennials that are continuing to be dependent

on their parents?

What is your hypothesis testing conclusion? Use a ά = .05 as the level of significance.