Regression Memo
Assignment Instructions and Supporting Documents
OVERVIEW:
• Prepare a 1 page memo with a second page attachment (this will have the scatterplot) to the target of your assigned data set (so, it is actually a 2 page document).
• Explain the regression analysis you have in your Excel file focusing on what the analysis means to the company and without using any of the statistical terms associated with regression analysis.
SCENARIO:
You are hired as a research assistant to analyze the data from a particular study and write a memo regarding aspects of your analysis and, where appropriate, make recommendations.
Your memo should be written to the individual and organization designated in your project theme described in the file BUGN 280 Excel Project Data File Information and look similar to the sample memo below for Data Set 1 as far as content and formatting.
YOUR MEMO MUST INCLUDE:
1. Your scatterplot with a regression line. By checking the right box in your software, the regression analysis will produce this chart for you. Format the chart to make it easy to read, adding a title and axis labels.
2. Four basic regression statistics: correlation coefficient, coefficient of determination, slope and y-intercept.
3. Explanation of your regression analysis, why you are using regression, what information is provided by each statistic, and the scatterplot. Explain the difference between correlation and regression, explain what each statistic means, and interpret each in practical terms.
4. Be resourceful. Leverage everything you can to help you. This is what it's like on the job.
Deliver your task on time and with the information requested.
This is the Assessment of Learning for the School of Business Learning Goal 2a.
2. Be effective in (a) written and (b) oral communications and in the use of appropriate supporting electronic technologies.