Scenario

Nightingale Shoes has hired you to run consulting work for their company. They need to understand the demographic and gender that is purchasing their shoes to determine how they should advertise. They also need you to compare their shoe sales during two different years.

The spreadsheet below contains three hypothesis tests to run.

Instructions

Work through each hypothesis test in the spreadsheet above and answer all questions provided. Note that each question is presented on a separate tab in the spreadsheet.

You must submit the spreadsheet with the completed calculations, answers, and analysis. Ensure that you are completely answering all questions with steps shown, explanations, and correct formatting.

AutoSave . OFF 1 STA 3215 Deliverable 5 - Hypothesis Tests for Two Samples Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA = ab Wrap Text General Insert v Ex AY- O. 4 Ex Delete v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Paste BIUVE E Merge & Center v Formatting as Table Styles Format v Filter Select Data D11 4 X V fx D E F G H 1 K L M N 0 P Q R S T U V W X 1. Population Proportions Nightingale Shoes is trying to determine the demographic who is purchasing their shoes. After surveying customers who enter their store, they find that 205 out of 369 adults between the age of 20 to 29 were purchasing their shoes. They also discovered that 105 out of 213 adults aged 30 to 39 were purchasing their shoes. Test the claim that younger adults (aged 20 to 29) purchase more Nightingale shoes than older adults (aged 30 to 39). Assume a 0.01 significance. 10 Adults aged 20 to 29 Adults aged 30 to 39 11 12 n : n 2 13 15 16 la. Write the hypotheses in symbolic form, determine if the test is right-tailed, left-tailed, or two tailed and explain why. 17 18 19 1b. Calculate the pooled sample proportion and the test statistic. Explain your calculations and include your results. 30 31 32 33 34 35 Pooled Sample Proportion 36 q-ba Test Statistic 1c. Calculate the critical value and make a decision about the null hypothesis. Explain your calculations, include your results, and explain how you arrived at your decision. Question 1 Question 2 Question 3 + + 100%1 STA 3215 Deliverable 5 - Hypothesis Tests for Two Samples Q AutoSave . OFF Share Comments Home Insert Draw Page Layout Formulas Data Review View Tell me Insert v Calibri (Body) * 11 AA = ab Wrap Text General Ex AY - O. 4 Ex Delete v Conditional Format Cell Sort & Find & Analyze Sensitivity Paste BIU E E Merge & Center v $ ~ % " Formatting as Table Styles Format v v Filter Select Data D11 4 X V fx D E F G H 1 K L M N 0 P Q R S T U V w X 38 Ic. Calculate the critical value and make a decision about the null hypothesis. Explain your calculations, include your results, and explain how you arrived at your decision. 44 45 46 47 48 Critical Value 1d. Calculate the p-value and make a decision about the null hypothesis. Explain your calculations, include your results, and explain how you arrived at your decision. 58 59 60 p-value le. Restate your conclusion in nontechnical terms. 71 72 73 74 75 76 77 80 81 Question 1 Question 2 Question 3 + + 100%AutoSave . OFF 1 STA 3215 Deliverable 5 - Hypothesis Tests for Two Samples Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Calibri (Body) * 11 AA = = ab Wrap Text General Ex AY - O. 4 Ex Delete v E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Paste BIU BY OvAv Formatting as Table Styles Format v Filter Select Data J14 A C D E F G H 1 J K L M N 0 P Q R U V w X Z 2. Population Means - Independent Samples Nightingale shoes is interested to know who is spending more on their brand: women or men. They surveyed the first 200 people who entered their store. They found that 89 men on average spent $65 with a standard deviation of $6. On the other hand, 111 women spent $72 with a standard deviation of $23. Test the claim that women spend more on Nightingale shoes then men. Assume a 0.05 significance level and the population standard deviations are unknown Men Spending Women Spending n2 13 15 16 2a. Write the hypotheses in symbolic form, determine if the test is right-tailed, left-tailed, or two tailed and explain why. 26 2b. Calculate the critical value, the test statistic, and p-value. Show calculations below. Explain your calculations and include your results. 35 36 37 38 Critical Value Test Statistic p-value 2c. Make a decision about the null hypothesis using both the Critical Value and P-Value Methods. Explain how you arrived at your results Question 1 Question 2 Question 3 + - + 100%Q AutoSave . OFF 1 STA 3215 Deliverable 5 - Hypothesis Tests for Two Samples Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Calibri (Body) * 11 AA" ag Wrap Text General Ex AY - O. Ex Delete v E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Paste BIU BY OvAv Formatting as Table Styles Format v Filter Select Data J14 A D E F G H J K L M N P Q R S T U V w X Y Z 2c. Make a decision about the null hypothesis using both the Critical Value and P-Value Methods. Explain how you arrived at your results. 2d. Restate your conclusion in nontechnical terms. Question 1 Question 2 Question 3 + - + 100%AutoSave . OFF 1 STA 3215 Deliverable 5 - Hypothesis Tests for Two Samples Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA = = ab Wrap Text v General Insert v Ex AY - O. 4 Ex Delete v Paste BIU E E Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data 111 4 fx A D E F G H 1 K L M N 0 P Q R S T U V W X Z 3. Population Means - Dependent Samples Nightingale shoes is looking at the productivity of a sample of its stores. They look at the average number of shoe sales per month in 2019 and compare the results with the average number of shoe sales per month in 2020. Based on the data in the table below, test the claim that the average number of monthly shoe sales is more in 2019 than in 2020 using a 0.1 significance level. Assume that the population standard deviations are unknown Month 2019 2020 10 January 2187 2148 Febrary 2722 2701 March 3383 1686 df April 3043 462 May 3018 1624 June 2796 2692 July 3093 2722 August 3988 2822 September 2594 2643 October 2721 2677 November 3038 2617 December 4044 3824 3a. Write the hypotheses in symbolic form, determine if the test is right-tailed, left-tailed, or two tailed and explain why. 25 26 27 28 29 30 3b. Calculate the critical value, the test statistic, and p-value. Show calculations below. Explain your calculations and include your results. 36 37 Question 1 Question 2 Question 3 + - + 100%1 STA 3215 Deliverable 5 - Hypothesis Tests for Two Samples Q AutoSave . OFF Share Comments Home Insert Draw Page Layout Formulas Data Review View Tell me Insert v Calibri (Body) * 11 AA ap Wrap Text v General Ex AY- O. 4 Ex Delete v Cell Sort & Find & Analyze Sensitivity Paste BIUVE E = Merge & Center v $ ~ % " Conditional Format Formatting as Table Styles Format v v Filter Select Data 111 4 X V fx E F G H 1 K L M N 0 P Q R S T U V W Z 33 34 3b. Calculate the critical value, the test statistic, and p-value. Show calculations below. 35 Explain your calculations and include your results. 36 37 38 39 40 Critical Value Test Statistic 46 p-value 3c. Make a decision about the null hypothesis using both the Critical Value and P-Value Methods. Explain how you arrived at your results. 3d. Restate your conclusion in nontechnical terms. 72 73 74 75 76 Question 1 Question 2 Question 3 + + 100%