This assignment is based loosely on Question #74 on page 465 of the textbook (Anderson, D.R., et al, 2020). The numbers are different so do not use the question from the book. Members of the millennial generation are continuing to be dependent on their parents (either living with or otherwise receiving support from parents) into early adulthood. In July 2020, during the pandemic, 52% of millennials were living in their parents' home, up from 47% in February, according to the Pew analysis of Census Bureau data, surpassing the previous high hit in 1940, when 48% of young adults lived with their parents. Suppose that a sample of 400 individuals aged 18 to 32 showed that 240 of them continue to be dependent on their parents.

a. Develop hypothesis for a test to determine whether the proportion of millennials continuing to be dependent on their parents is higher than the past generations since July of 2020? (This is a formula.)

b. What is your point estimate of the proportion of millennials that are continuing to be dependent on their parents? (Show work.)

c. What is the p-value provided by the sample data? (Show work.)

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

Requirement: Submit your Excel spreadsheet and written conclusion here. Your conclusion can be written on the Excel spreadsheet, in a Word document, or typed in the textbox. You will be graded on your completion of the calculations in Excel and the explanation of your conclusion. Remember to use good grammar, spelling, and punctuation in your explanation and include citations if references are used to support your explanation. This assignment is worth 50 points.

CAN YOU PLEASE DO THIS ASSIGNMENT ON A EXCEL SPREADSHEET BECAUSE THAT'S THE REQUIREMENT.