Assignment-
Question 1. Descriptive analysis
a. Prepare appropriate summary statistics on each variable and comment on each of these.
b. Also look at the histograms and the separate line plots for each company. Comment.
c. Use a PivotTable to compare the number of crews used in the two companies
Question 2. Create a new variable for each company, viz., the ratio of
The number of Offices cleaned/Number of crews
Call these variables OCA and OCB
Your client wants to know which company has the lower mean OC (why does he want this statistic?). Other information suggests that company B might have the higher mean. Test this hypothesis at 5% level of significance. Set out your analysis for this fully. What can be recommended to your client?
Question 3. For the company chosen in 2, your boss wants you to fit a simple linear regression model to the data. Incorporate appropriate output in your report.
y = Number of Rooms cleaned
x = Number of Crews
A. Justify the choice of explanatory and dependent variables.
B. Estimate the regression equation between these variables.
1. State and interpret the slope coefficient.
2. State and interpret the R2 value from this.
3. Give a final summary of your findings from this regression.
Attachment:- Data.rar