Groups: Complete in groups of 1 to 3 students

Memorandum (11 pts)
Write a brief memo (200-300words or less) summarizing your findings (both descriptive statistics about your sample and inferential statistics (ie hypothesis test and confidence intervals, where appropriate)) about calories and sodium across hot dog type for your friend. Your friend has not taken statistics before so be sure to write the summary appropriately. You will need to interpret and write up the results in a form that will make sense to a non-statistician. The memorandum should NOT contain technical jargon. Any tables and/or graphs must be clearly labeled and explained. This memo is a stand-alone file. Do not refer to tables/figures in the Appendix. A discussion of the memo format is included below.

Statistical Analysis (Appendix 14 points)
Include your statistical analysis that is clearly and completed documented. The Appendix should be written in Word and you should import the relevant Excel tables and results (not every table) into Word to make formatting easier. Do NOT include the raw data, just relevant tables and analysis of the tables. For any hypothesis tests, be sure to clearly indicate your hypotheses, test statistic, p-value and conclusion.
The analysis plan is broken into steps for you below.

1. (2 points) Compute summary statistics for calories by type of hot dog – find the summary statistics of calories for each type of hot dog (beef, meat, and chicken).
Follow the table template below (Hint, a pivot table will do this easily). Include your table in your assignment — round appropriately!
Based on the summary statistics, do the average number of calories appear to be different across hot dog types?
Table 1: Calories summary statistics by type of hot dog
n Average SD Min Max
Beef
Meat
Poultry
All hot dogs
2. (1 point) Include a bar graph (Excel calls them column charts) comparing the average calories for each type of hot dog.
3. (2 points) Conduct a One-way ANOVA test to determine if the differences between average calories across hot dog typesare statistically significant. What are the hypotheses using notation (e.g., include µ’s in your hypotheses)? In Excel using the “Data Analysis toolPak”, conduct “Anova Single Factor” analysis. Include the ANOVA table. What are the F test statistic and p-value for the hypothesis test? What is your conclusion?
Hint: In order to run your analysis, you will have to reorganize you data! Each column should represent a type of hot dog.

4. (2 points) If your One-way ANOVA is significant, conduct post-hoc tests using a Bonferroni correction. For each pairwise test, include your hypotheses using notation (e.g., include µ’s in your hypotheses), test statistic, p-value and your conclusion.
If your One-way ANOVA is not significant, we can lump all hot dogs together and ignore the type of hot dog. Calculate a 95% confidence interval for the average number of calories in hot dogs, ignoring the type of hot dog. Interpret the interval

5. (7 points) Repeat 1-4 but this time comparing the average sodium level for each type of hot dog.
• Summary statistics of sodium by hot dog type
• Bar chart comparing average sodium by hot dog type
• One-way ANOVA of average sodium by hot dog type
• If ANOVA is significant, conduct Bonferroni corrected post-hoc tests. If ANOVA is not significant, calculate a 95% confidence interval of average sodium, ignoring hot dog types

BONUS (1 point): Check the assumptions for the One-way ANOVA of calories. Include what you used to check the assumptions and your evaluation of the assumptions.

REQUIRED CASE STUDY 1 MEMO FORMAT.
Adapted from Purdue Online Writing Lab: https://owl.english.purdue.edu/owl/resource/590/02/

TO: (readers’ names and job titles)
FROM: (your name and job title)
DATE: (complete and current date)
SUBJECT: (what the memo is about, highlighted in some way)

The first paragraph is the “Opening+Context+Task” segment. In this paragraph, include the purpose of the memo, the context and problem, and your key recommendation. Justification of your key recommendation should not be included in the first paragraph. It will be included in the next section.

The next section is the “Discussion” segment. This is the longest section of the memo and includes all of the details and reason for your recommendation, including a description of the data (sample size and key features).

In this paragraph, address goal 1, which discusses the caloric count across different hot dog types.

In the next paragraph of the “Discussion” segment, address goal 2, which discusses the sodium content across different hot dog types.

In the “Closing” segment, “you want to close with a courteous ending that states what action you want your reader to take. Make sure you consider how the reader will benefit from the desired actions and how you can make those actions easier.For example, you might say, ‘I will be glad to discuss this recommendation with you during our Tuesday trip to the spa and follow through on any decisions you make.’” (Purdue Online Writing Lab)

Attached: (indicate what files are attached, be concise and descriptive)