Simple Regression Analysis

Study on regression techniques and their applications in data analysis.

Alexander Wilson
Contributor
4.2
46
5 months ago
Preview (2 of 2 Pages)
100%
Purchase to unlock

Page 1

Simple Regression Analysis - Page 1 preview image

Loading page ...

Simple Regression AnalysisUse the data in the chart to answer the questions below.The data indicates the number of “sickdays” appliance installers take during a three month period, and the number of complaints filedby customers during the same interval. Use the Analysis Toolpak in Excel to perform this simpleregression and answer the questions.a.Is the correlation between number of sick days and number of customer complaintsstatistically significant?b.What is the best prediction for the number of complaints that will be registered for aninstaller 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 documentto the discussion post.Sickdays (x)Complaints(y)x*2y*2xy2349656253630451625201319334916125725493544161616693681543041132241176This is a two tailed hypothesis.The correlation between the sick days and amount of complaints is 0.9068 the equation expressesit.Work for (A) below:We can test this statistic by this formulation:

Page 2

Study Now!

XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

Subject
Statistics

Related Documents

View all