PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced...

PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS

Repair Time in Hours	Months Since Last Service	Type of Repair	Repairperson
2.9	2	Electrical	Dave Newton
3	6	Mechanical	Dave Newton
4.8	8	Electrical	Bob Jones
1.8	3	Mechanical	Dave Newton
2.9	2	Electrical	Dave Newton
4.9	7	Electrical	Bob Jones
4.2	9	Mechanical	Bob Jones
4.8	8	Mechanical	Bob Jones
4.4	4	Electrical	Bob Jones
4.5	6	Electrical	Dave Newton

Ignore for now the months since the last maintenance service (x₁) and the repairperson who performed the service. Develop the estimated simple linear regression equation to predict the repair time (y) given the type of repair (x₂). Recall that x₂ = 0 if the type of repair is mechanical and 1 if the type of repair is electrical.
Does the equation that you developed in part (a) provide a good fit for the observed data? Explain.
Ignore for now the months since the last maintenance service and the type of repair associated with the machine. Develop the estimated simple linear regression equation to predict the repair time given the repairperson who performed the service. Let x₃ = 0 if Bob Jones performed the service and x₃ = 1 if Dave Newton performed the service.
Does the equation that you developed in part (c) provide a good fit for the observed data? Explain.
Develop the estimated regression equation to predict the repair time given the number of months since the last maintenance service, the type of repair, and the repairperson who performed the service.
At the .05 level of significance, test whether the estimated regression equation developed in part (e) represents a significant relationship between the independent variables and the dependent variable.
Is the addition of the independent variable x₃, the repairperson who performed the service, statistically significant? Use α = .05. What explanation can you give for the results observed?

Solutions

Expert Solution

orchestra answered 10 months ago

Next > < Previous

Related Solutions

Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information...

Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair Repairperson 2.9 2 Electrical Dave Newton 3.0 6 Mechanical Dave Newton 4.8 8 Electrical Bob Jones 1.8 3...

Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information...

Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Use Excel Formula(Excel only) Repair Time in Hours Months Since Last Service Type of Repair Repairperson 2.9 2 Electrical Dave Newton 3.0 6 Mechanical Dave Newton 4.8 8 Electrical...

How can I solve this in Excel? Please show how to solve it in excel step...

How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...

***Excel is required to solve this problem. Please use excel and show all formulas used in...

***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...

Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary

Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair Repairperson 2.9 2 Electrical Dave Newton 3 6 Mechanical Dave Newton 4.8 8 Electrical Bob Jones 1.8...

* PLEASE SHOW HOW TO SOLVE IN EXCEL* Case Problem 2: Finding the Best Car Value...

*** PLEASE SHOW HOW TO SOLVE IN EXCEL*** Case Problem 2: Finding the Best Car Value (Copy the worksheet named “FamilySedans” in QMB3200-Homework#10Data.xlsx into your file for this problem) When trying to decide what car to buy, real value is not necessarily determined by how much you spend on the initial purchase. Instead, cars that are reliable and don’t cost much to own often represent the best values. But, no matter how reliable or inexpensive a car may cost to...

PLEASE SHOW HOW TO SOLVE IN EXCEL Case Problem 3: Consumer Research, Inc. (Copy the worksheet...

***PLEASE SHOW HOW TO SOLVE IN EXCEL*** Case Problem 3: Consumer Research, Inc. (Copy the worksheet named “Consumer” in QMB3200-Homework#10Data.xlsx into your file for this problem) Consumer Research, Inc., is an independent agency that conducts research on consumer attitudes and behaviors for a variety of firms. In one study, a client asked for an investigation of consumer characteristics that can be used to predict the amount charged by credit card users. Data were collected on annual income, household size, and...

Please solve using EXCEL SOLVER and show steps 1 – A company requires during the next...

Please solve using EXCEL SOLVER and show steps 1 – A company requires during the next four months, respectively, 50, 65, 100, and 70 units of a commodity (no backlogging is allowed). Production costs are $5, $8, $4, and $7 per unit during these months. The storage cost from one month to the next is $2 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 could be sold for...

Can you please not solve this on excel. can you show clearly steps you took. Thanks...

Can you please not solve this on excel. can you show clearly steps you took. Thanks An office uses 1,000 photocopies per working day and there are 200 working days per year. Brand A copier costs $3,000 and will produce a total of one million copies before it wears out. Brand B’s copier costs $5,000 and will produce 2 million copies over its life. Maintenance and materials cost 3 cents pr copy with either machine, and neither machine will have...

PLEASE SHOW HOW TO SOLVE IN EXCEL NOT HANDWRITTEN 6) The time needed to complete a...

***PLEASE SHOW HOW TO SOLVE IN EXCEL*** NOT HANDWRITTEN 6) The time needed to complete a final examination in a particular college course is normally distributed with a mean of 90 minutes and a standard deviation of 15 minutes. Answer the following questions. a. What is the probability of completing the exam in one hour or less? b. What is the probability that a student will complete the exam in more than 60 minutes but less than 105 minutes? c....

Subjects