Assume the following data (where the xxx is the last three digits of your panther id):...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assume the following data (where the xxx is the last three digits of your panther id): Month Machine Heurs (hrs.) Maintenance Costs (5) 1.240 1,400 1.220 1,470 1.620 1.660 1.490 1.280 1,450 1.580 2 3 14 5 6 8 19 10 11 1,300 12 1,600 13 1.650 14 1.440 15 1,350 16 1.680 17 1,480 18 1.360 19 1340 20 21 22 23 1.540 1.320 1,410 1.230 103,XXX 107,xxx 102,xxx 108,XXX 116,XXX 115,xxx 107.xxx 101.XXX 106,xxx 113,xxx 100,XXX 113,xxx 113.ххх 109,xxx 102,XXX 117.xxx 106,xxx 103,XXX 103,xxx 112,XXX 102,xxx 104,Xxxx 101,xxx For example, if your panther id is 1234567, then your maintenance costs would be $103,567 in month 1; $107,567 is month 2; $113,567 in months 10, 12, and 13. Assume that the following relationship holds: Maintenance Costs = a + (b Machine Hours) REQUIRED Estimate the values of a and b, using, 1. the High-Low Method, and (8 Points) 2. the Linear Regression method (8 Points) For help outside of the textbook, try "Linear Regression in Excel" on YouTube Note, to use the linear regression method, you MUST use the Microsoft Excel program. Make sure to report i). the values of a and b ii) a scatter plot of the data points, and iii) the R-square or the adjusted R-square 3. Which of the above two methods is more appropriate? Why? (3 sentences maximum) Assume the following data (where the xxx is the last three digits of your panther id): Month Machine Heurs (hrs.) Maintenance Costs (5) 1.240 1,400 1.220 1,470 1.620 1.660 1.490 1.280 1,450 1.580 2 3 14 5 6 8 19 10 11 1,300 12 1,600 13 1.650 14 1.440 15 1,350 16 1.680 17 1,480 18 1.360 19 1340 20 21 22 23 1.540 1.320 1,410 1.230 103,XXX 107,xxx 102,xxx 108,XXX 116,XXX 115,xxx 107.xxx 101.XXX 106,xxx 113,xxx 100,XXX 113,xxx 113.ххх 109,xxx 102,XXX 117.xxx 106,xxx 103,XXX 103,xxx 112,XXX 102,xxx 104,Xxxx 101,xxx For example, if your panther id is 1234567, then your maintenance costs would be $103,567 in month 1; $107,567 is month 2; $113,567 in months 10, 12, and 13. Assume that the following relationship holds: Maintenance Costs = a + (b Machine Hours) REQUIRED Estimate the values of a and b, using, 1. the High-Low Method, and (8 Points) 2. the Linear Regression method (8 Points) For help outside of the textbook, try "Linear Regression in Excel" on YouTube Note, to use the linear regression method, you MUST use the Microsoft Excel program. Make sure to report i). the values of a and b ii) a scatter plot of the data points, and iii) the R-square or the adjusted R-square 3. Which of the above two methods is more appropriate? Why? (3 sentences maximum)
Expert Answer:
Answer rating: 100% (QA)
Answer Please accept my Answer Calculation MH In the equation maintenanc... View the full answer
Related Book For
Principles of Accounting
ISBN: 978-1133626985
12th edition
Authors: Belverd E. Needles, Marian Powers and Susan V. Crosson
Posted Date:
Students also viewed these mathematics questions
-
Assume the following data for Lusk Inc. before its year-end adjustments: Journalize the adjusting entries for the following: a. Estimated customer allowances b. Estimated customer returns? Unadjusted...
-
Assume the following data for Casper Company before its year-end adjustments: Journalize the adjusting entries for the following: a. Estimated customer allowances b. Estimated customer returns?...
-
Assume the following data for Oshkosh Company before its year-end adjustments: Journalize the adjusting entries for the following: a. Estimated customer refunds and allowances b. Estimated customer...
-
Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them...
-
You mix equal moles of N2, O2, and NO and place them into a container fitted with a movable piston. Then you heat the mixture to 2127oC, compressing the mixture with the piston to 10.0 atm, where the...
-
An autocratic form of group decision-making is where Decisions are taken solely by the leader of that group and the success or failure of implementing that decision lies with the leader themselves ...
-
A vertical jet of water leaves a nozzle at a speed of \(10 \mathrm{~m} / \mathrm{s}\) and a diameter of \(20 \mathrm{~mm}\). It suspends a plate having a mass of \(1.5 \mathrm{~kg}\) as indicated in...
-
Determine the present value of $750,000 to be received in three years, using an interest rate of 12%, compounded annually. a. Use the present value table in Exhibit 4. b. Why is the present value...
-
Nike had sales of $44.487 billion in 2021. Suppose you expected its sales to grow at a rate of 18% in 2022, but then slow by 3% per year to the long-run growth rate that is characeristic of the...
-
In this lab, we will use the inverse kinematics to identify two functions to generate an animation of a two-link robot. As mentioned in the previous section, the lengths of the two links are a = 3 ft...
-
Kubin Company s relevant range of production is 2 4 , 0 0 0 to 3 1 , 0 0 0 units. When it produces and sells 2 7 , 5 0 0 units, its average costs per unit are as follows: Average Cost per Unit Direct...
-
Write a program that takes a start string and a stop string as commandline arguments and prints all substrings of a given string that start with the first, end with the second, and otherwise contain...
-
Develop a data type for the naming scheme for vehicles known as the Vehicle Identification Number (VIN). A VIN describes the make, model, year, and other attributes of cars, buses, and trucks in the...
-
Implement the method toString() for BST, using a recursive helper method like traverse(). As usual, you can accept quadratic performance because of the cost of string concatenation. Extra credit:...
-
Add a method isReachable(v) to PathFinder that returns true if there exists some path from the source to \(v\), and false otherwise.
-
Write a program that plots average path length versus the number of random edges as random shortcuts are added to a 2-ring graph on 1,000 vertices.
-
Use the normal distribution of heights of adult women, which has a mean of 165 centimeters and a standard deviation of 5 centimeters, and the following table with the standard scores and percentiles...
-
Phosgene, COCl2, is a toxic gas used in the manufacture of urethane plastics. The gas dissociates at high temperature. At 400oC, the equilibrium constant Kc is 8.05 104. Find the percentage of...
-
State Street Lending processes loan applications. The manager of the loan department has established a policy of charging a $250 fee for every loan application processed. Variable costs have been...
-
Forensics Company provides fraud monitoring services. It employs five fraud specialists. Each specialist works an average of 200 hours a month. The companys controller has compiled the information...
-
Waterbury Corporation issued $16,000,000 in 8.5 percent, five-year bonds on March 1, 2014, at 96. The semiannual interest payment dates are September 1 and March 1. Prepare the journal entries to...
-
If a politician running for office does not speak in general terms, does not try to move to the middle of the political spectrum, and does not take polls, is the median voter model therefore wrong?
-
Voters often criticize politicians running for office who do not speak in specific terms (i.e., who do not specify which spending programs will be cut, whose taxes will be raised, etc.). If voters...
-
Suppose the United States can produce 120 units of X at an opportunity cost of 20 units of Y and the United Kingdom can produce 40 units of X at an opportunity cost of 80 units of Y. Identify...
Study smarter with the SolutionInn App