# The following information on maintenance and repair costs and revenues for the last two years is...

###### Question:

The following information on maintenance and repair costs and revenues for the last two years is available from the accounting records at Arnie’s Arcade & Video Palace. Arnie has asked you to help him understand the relation between business volume and maintenance and repair cost.

 Month Maintenance and Repair Cost ($000) Revenues ($000) July $2.16$56.00 August 3.13 50.00 September 2.65 46.00 October 2.06 62.00 November 2.15 74.00 December 0.99 102.00 January 2.97 42.00 February 3.01 48.00 March 2.87 58.00 April 2.83 60.00 May 1.89 64.00 June 1.63 76.00 July 2.45 70.00 August 1.87 64.00 September 2.42 72.00 October 2.23 74.00 November 1.28 84.00 December 0.61 114.00 January 2.43 58.00 February 2.13 60.00 March 1.54 80.00 April 1.80 84.00 May 1.80 70.00 June 1.42 66.00

Required:

Using Excel, estimate a linear regression with maintenance and repair cost as the dependent variable and revenue as the independent variable. (Negative amounts should be indicated by a minus sign. Round "Multiple R, R Square and Standard Error" to 7 decimal places, "Intercept and Revenues" to 4 decimal places.)

 Regression Statistics Multiple R R Square Standard Error Observations Coefficients. Intercept Revenues.

#### Similar Solved Questions

##### Create Balance Sheet for GoPro 2018,2017,2016 Annual Data - Income Statement (GoPro) 2018 2017 2016 Revenue...
Create Balance Sheet for GoPro 2018,2017,2016 Annual Data - Income Statement (GoPro) 2018 2017 2016 Revenue Cost of Goods Sold Gross Profit Operating Expenses Operating Income Pre-Tax Income Income After Taxes Income from Continuous Oper...
##### Response for 150 individuals is as given below and we are interested in determining whether or...
Response for 150 individuals is as given below and we are interested in determining whether or not the opinions of the individuals are uniformly distributed. Do you support capital punishment? Number of individuals Yes 40, No 60, No Opinion 50 The p-value is a. < 0.05 b. > 0.9 c. < 0.1 d. &...
##### Please refer to illustration for question. With the given positive numbers, show that the vectors u...
Please refer to illustration for question. With the given positive numbers, show that the vectors u = (Uį, uz) and v = (v1, v2) define an inner product in R2 using the 4 axioms. Set u, v = 3u1 V1 + 7u2V2...
##### How do you solve sin2x + 2 sinx cosx - 1= 0?
How do you solve sin2x + 2 sinx cosx - 1= 0?...
##### The answer is there but the method was confusing 7B.4 Flow between two tanks. Case 1:...
The answer is there but the method was confusing 7B.4 Flow between two tanks. Case 1: A fluid flows between two tanks A and B because Pa > PB. The tanks are at the same elevation and there is no pump in the line. The connecting line has a cross-sectional area S, and the mass rate of flow is w fo...
##### Wildhorse Co. began operations on July 1. It uses a perpetual inventory system. During July, the...
Wildhorse Co. began operations on July 1. It uses a perpetual inventory system. During July, the company had the following purchases and sales. Purchases Date Units Unit Cost Sales Units July 1 5 $166 July 6 3 July 11 6$180 July 14 5 July 21 7 \$1...
##### Name: Be sure to show your work for potential partial credit! 1. An engineer is going to redesign an ejection seat for...
Name: Be sure to show your work for potential partial credit! 1. An engineer is going to redesign an ejection seat for an airplane. The seat was designed for pilots weighing between 130 lb and 191 lb. The new population of pilots has normally distributed weights with a mean of 138 lb and a standard ...
##### CO2 can be eliminated and transformed to fuel like CH4 by the following reaction: CO2(g) +...
CO2 can be eliminated and transformed to fuel like CH4 by the following reaction: CO2(g) + 4H2(g) → 2H2O(g) + CHa(g) Figure below shows 1 mol of CO2 entering at 800 K and reacting with 4 mol of Hz entering at 298 K while the product exits the reactor at 1000 K. 1 mol CO2 800 K Product 1000K Rea...
##### 6. Provide the IUPAC name or structure of the following alkenes including the appropriate E or...
6. Provide the IUPAC name or structure of the following alkenes including the appropriate E or Z prefix. (See problems 4.8-12 for similar examples.) Circle the high-priority groups on each carbon. (Name the benzene ring as a substituent with the name "phenyl.") a. CH2CH3 H3C CH b. E-3-chloro...
##### Show that the matrix is not diagonalizable. 2 43 0 21 0 03 STEP 1: Use...
Show that the matrix is not diagonalizable. 2 43 0 21 0 03 STEP 1: Use the fact that the matrix is triangular to write down the eigenvalues. (Enter your answers from smallest to largest.) -- STEP 2: Find the eigenvectors x, and X corresponding to d, and 12, respectively, STEP 3: Since the matrix doe...
##### Problem 3: 15–35. The 5-Mg bus B is traveling to the right at 20 m/s. Meanwhile...
Problem 3: 15–35. The 5-Mg bus B is traveling to the right at 20 m/s. Meanwhile a 2-Mg car A is traveling at 15 m/s to the right. If the vehicles crash and become entangled, determine their common velocity just after the collision. Assume that the vehicles are free to roll during collision....
##### Answer a total of any THREE out of the four questions. Put the solution to each problem in a separate blue book and put the number of the problem and your name on the front of each book. If you su...
Answer a total of any THREE out of the four questions. Put the solution to each problem in a separate blue book and put the number of the problem and your name on the front of each book. If you submit solutions to more than three problems, only the first three problems as listed on the exam will be ...