Simple Regression Analysis

Preview 2 of 2 pages

See the first 2 pages exactly as they appear in the document.

Page 1
Read page 1 as text
Simple Regression Analysis Use the data in the chart to answer the questions below. The data indicates the number of “sick days” appliance installers take during a three month period, and the number of complaints filed by customers during the same interval. Use the Analysis Toolpak in Excel to perform this simple regression and answer the questions. a. Is the correlation between number of sick days and number of customer complaints statistically significant? b. What is the best prediction for the number of complaints that will be registered for an installer who takes five sick days during the period? Use Excel to help you answer the questions in the forum but do not attach your Excel document to the discussion post. Sick days (x) Complaints (y) x*2 y*2 xy 2 3 4 9 6 5 6 25 36 30 4 5 16 25 20 1 3 1 9 3 3 4 9 16 12 5 7 25 49 35 4 4 16 16 16 6 9 36 81 54 30 41 132 241 176 This is a two tailed hypothesis. The correlation between the sick days and amount of complaints is 0.9068 the equation expresses it. Work for (A) below: We can test this statistic by this formulation:
Page 2