Prepare appropriate summary statistics on each variable

Assignment Help Applied Statistics

Reference no: EM131089547 , Length: word count:500

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

Reference no: EM131089547

Questions Cloud

Trading desk use to hit the target federal funds rate : To hit the target federal funds rate given in the FOMC‘s policy directive, Does the manager of the Trading Desk adjust demand for reserves, the supply of reserves, or both? What monetary policy tool does the manager of the Trading Desk use to hit the..

Demand and supply curve-determine equilibrium price-quantity : Suppose the demand and supply of chickens is given by: Graph the demand and supply curves and determine the equilibrium price and quantity. Suppose a quota of 4000 chickens in imposed. What will be the new equilibrium price? What is the loss to consu..

Cause low deadweight loss : Suppose your mayor has asked you to come up with an excise tax that will be as efficient as possible. Choose a good to be taxed and explain why it will cause a low deadweight loss.

What is the currency used by the japan : The US basically uses dollar as its currency form. What is the currency used by the Japan?

Prepare appropriate summary statistics on each variable : BUS201 Assignment. Descriptive analysis, Prepare appropriate summary statistics on each variable and comment on each of these. Also look at the histograms and the separate line plots for each company. Comment

Consumers distributed uniformly around the circle : Suppose there are 8 firms located equidistantly around a circle whose circumference is equal to 1. There are 400 consumers distributed uniformly around the circle. Each consumer gets utility U = 3.5 from buying a unit of the good from a firm which se..

Which government is right for you : "Which government is right for you?" Perhaps a better way of saying it is this: would you like a caretaker type of government who looks out for you or would you like a hands-off type of government that basically let's you make your own decisions? For..

Designed to reduce moral hazard created by deposit insurance : Which of the following are regulations that are designed to reduce the moral hazard created by deposit insurance?

What is the present value of the growing perpetuity : What is the present value of a perpetual stream of cash flows that pays $80,000 at the end of one year and grows at a rate of 7% indefinitely?

User Account

All Pages