25 Garfield Company manufactures a popular brand of dog repellant known as DogGone it, which it sells in galon sue bottles with a spray attachment. The majority of Gerfekts business comes from orders placed by homeowners who are trying to keep neighborhood dogs out of thee yards Garteld's operating information for the first six months of the year follows Moth January ttles Sald 991 Cast $10,00 1,170 1, 15,750 Apr13 Pay 27,150 Required 3. Using the high low method, calculate Garfield's total fixed operating costs and vanable operating cost per bottle 4. Perform a least-squares regression analysis on Garfeld's data 5. Determine how well this regression analysis explains the data 6. Using the regression output create a linear cost equation (ya+be for estimating Garfield's operating costs Complete this question by entering your answers in the tabs below. Re Using the high-low method, calolate Garfield's total fixed operating costs and variable operating cost per bottle (D round your intentedate calculations. Round your variable cost per unt answer to 2 decimal places and fixed cost answer to the nearest le number) Vare Cost per Sh Find Required> Help Save & Exit Sub 25 Garfield Company manufactures a popular brand of dog repellant known as DogGone It, which it sets in gallon size bottles with a spray attachment The majority of Garfield's business comes from orders placed by homeowners who are trying to keep neighborhood dogs out of their yards Garfield's operating information for the first six months of the year follows Operating Cost ninth January February Ranch April Play Je Bottles Sold $18,500 1,300 15,750 1,750 15,0 2,150 19,578 Required: 3. Using me high low method, calculate Garfield's total fixed operating costs and variable operating cost per bote 4. Perform a least-squares regression analysis on Garfield's data 5. Determine how well this regression analysis explains the data 6. Using the regression output, create a linear cost equation (y-a-bd for estimating Gard operating costs Complete this question by entering your answers in the tabs below. Red Seed 4 Reqared S Perform a least squares regression analysis on Garfield's data. (Use Hcrosoft Excel or a statistical pocket bed the 2 decimal places) efficients ung leit-squares regression Round your answers Intercept Vare Coefficient Required Required> June 3,650 34,040 25 Required: 3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle 4. Perform a least-squares regression analysis on Garfield's data 5. Determine how well this regression analysis explains the data 6. Using the regression output, create a linear cost equation (ya bx) for estimating Garfield's operating costs. Complete this question by entering your answers in the tabs below. Required 3 Reqared 4 Required S Required 6 Determine how well this regression analysis explains the data. (Round you regression statistics to three decimal places and your percentage answer to the nearest whole number) Multiple R Regression Statistics R Square Adjusted R Square Standard Emor Observations From the regression output number of bottles explains about of the variability in Garfield's total cost 25 Garfield Company manufactures a popular brand of dog repellant known as DogGone it, which it seits in gollon-size bottles with a spray attachment. The majority of Garfield's business comes from orders placed by homeowners who are trying to keep neighborhood dogs out of their yards. Garfield's operating information for the first six months of the year follows Month January February Naber of Bottles Sold 990 Operating Cost $10,500 1,370 15,750 March 1,750 15,940 April May 2,350 19,570 3,440 June 27,150 34,840 Required: 3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle 4. Perform a least-squares regression analysis on Garfield's deta 5. Determine how well this regression analysis explains the data 6. Using the regression output, create a linear cost equation (y-ab) for estimating Garfield's operating costs Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Lising the regression output, create a linear cost equation (ya+hx) for estimating Garfield's operating costs. (Round your answers to 3 decimal places.) Titar Cost (Number Butes) Garfield Company manufactures a popular brand of dog repellant known as DogGone It, which it sells in gallon-size bottles with a spray attachment. The majority of Garfield's business comes from orders placed by homeowners who are trying to keep neighborhood dogs out of their yards. Garfield's operating information for the first six months of the year follows: Operating Cost Month Number of Bottles Sold January February 990 $10,500 1,370 15,750 March 1,750 15,940 April 2,350 19,570 May June 3,440 3,650 27,150 34,840 Required: 3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. 4. Perform a least-squares regression analysis on Garfield's data 5. Determine how well this regression analysis explains the data. 6. Using the regression output, create a linear cost equation (ya+b) for estimating Garfield's operating costs Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. (Do not round your intermediate calculations. Round your variable cost per unit answer to 2 decimal places and fixed cost answer to the nearest whole number.) June Required: 3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle 4. Perform a least-squares regression analysis on Garfield's data. 5. Determine how well this regression analysis explains the data. 6. Using the regression output, create a linear cost equation (ya+b) for estimating Garfield's operating costs Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. (Do not round your intermediate calculations. Round your variable cost per unit answer to 2 decimal places and fixed cost answer to the nearest whole number) Variable Cost per Unit Fixed Cost Required 4> May 3,440 27,150 June 3,650 34,840 Required: 3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle 4. Perform a least-squares regression analysis on Garfield's data 5. Determine how well this regression analysis explains the data. 6. Using the regression output, create a linear cost equation (y-a+ bx) for estimating Garfield's operating costs. Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 61 Perform a least-squares regression analysis on Garfield's data. (Use Microsoft Excel or a statistical package to find the coefficients using least-squares regression. Round your answers to 3 decimal places.) Coefficients X Variable 1 Intercept Required: 3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. 4. Perform a least-squares regression analysis on Garfield's data. 5. Determine how well this regression analysis explains the data 6. Using the regression output, create a linear cost equation (ya bx) for estimating Garfield's operating costs Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Determine how well this regression analysis explains the data. (Round you regression statistics to three decimal places and your percentage answer to the nearest whole number.) Mutiple R R Square Adjusted R Square Standard Error Observations From the regression output Regression Statistics number of bottles explains about of the variability in Garfield's total cost February March 1,750 15,940 April 2,350 19,570 May 3,440 June 3,650 27,150 34,840 Required: 3. Using the high-low method, calculate Garfield's total fixed operating costs and variable operating cost per bottle. 4. Perform a least-squares regression analysis on Garfield's data 5. Determine how well this regression analysis explains the data 6. Using the regression output, create a linear cost equation (ya+b) for estimating Garfield's operating costs Complete this question by entering your answers in the tabs below. Required 3 Required 4 Required 5 Required 6 Using the regression output, create a linear cost equation (y = a + bx) for estimating Garfield's operating costs. (Round your answers to 3 decimal places.) Total Glist=