Question: 5. Perform a least-squares regression analysis on Leslies data. (Use Microsoft Excel or a statistical package to find the coefficients using least-squares regression. Round your

5. Perform a least-squares regression analysis on Leslies data. (Use Microsoft Excel or a statistical package to find the coefficients using least-squares regression. Round your answers to 2 decimal places.)
6. Using the regression output, create a linear equation (y = a + bx) for estimating Leslies operating costs. (Round your answers to 2 decimal places.)
7. Using the least-squares regression results, calculate the stores expected operating cost if it prints 640 jerseys. (Round your intermediate calculations to 2 decimal places. Round your final answer to 2 decimal places.)
Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority of its business comes from orders for various local teams and organizations. While Leslie's prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company's biggest source of revenue. A portion of Leslie's operating information for the company's last year follows: Number of Jerseys Operating Cost $5,835 5,685 5,930 8,575 9,770 9,260 6,230 6,175 6,005 5,960 4,960 4,800 215 195 February 675 455 375 310 230 185 175 September November Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority of its business comes from orders for various local teams and organizations. While Leslie's prints everything from bowling team jerseys to fraternity/sorority apparel to special event shirts, summer league baseball and softball team jerseys are the company's biggest source of revenue. A portion of Leslie's operating information for the company's last year follows: Number of Jerseys Operating Cost $5,835 5,685 5,930 8,575 9,770 9,260 6,230 6,175 6,005 5,960 4,960 4,800 215 195 February 675 455 375 310 230 185 175 September November
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
