Mktg 3023 Applied Research Homework Needs Spss Software 2Question Description Part 1:Complete BOTH by hand and by computer (parts 5 and 6 use only computer if needed).A company that is in the business of making breakfast cereal wants to make the product more appealing to their cost conscious customer by revising the package design.In this effort they are considering 5 different package designs.They randomly showed the five packages to 20 customers and asked them to report their likelihood of purchasing the cereal. Results are provided below: Likelihood of purchasing the cerealDesign 155454Design 24344Design 3333Design 42342Design 54343

State the null and alternative hypothesis for this test. (please define your µs)What is the Test Statistic (When doing by hand show work else no credit) What is thep-value. What is the statistical and administrative decision at the 0.05 level of significance?Statistical Decision:Administrative Decision:If appropriate, conduct the Tukeys Test and clearly provide the results.(use only spss for this part).If you were the brand manager, which package design will you select and why? Please justify your conclusion? (use spss if needed to provide support for your answer)Part 2:Complete this problem using spss only. No need to do by hand. Data was collected from 20 individuals from a small town in Arkansas about their household income (low, medium, or high) and primary bank (First Federal Bank (FFB), Bank of America (B of A), U.S. Bank (USB), First National Bank & Trust (FNBT), all other bank). This is provided below. Primary HouseholdPerson Bank Income1 FFB Medium 2 B of A High3 USB Medium4 Other Low5 FNBT Low6 FFB Medium7 FFB Medium8 B of A High9 B of A Medium10 USB Medium11 USB Low12 Other Medium13 Other High14 Other Low15 FNBT Low16 FFB Medium17 USB Medium18 USB Low19 B of A High20 FNBT LowIt is important to determine if there is a relationship between household income and the primary bank.

State the null and the alternative hypothesis for this test.What is the value of the test statistic?What is the p-value?What is the statistical decision if the significance level is 0.05?What is the administrative decision?In July of 2018, the market share of the banks were FFB=21%, B of A=16%, USB=23%, FNBT=18%, and other banks=22%. You are interested in determining if these market shares are the same or different now (in 2019). What is the null and alternative hypothesis for this test?What is the value of the test statistic?What is the p-value?What is the statistical decision if the significance level is 0.05?What is the administrative decision?