Hey? Can some body please help me with this Problem of Cost Accounting?

How do you get R square and X Variable? Step by Step

Thank you.

Mary Sendler is the new manager of the materials storeroom for Walker Manufacturing. Mary has been asked to estimate future monthly purchase costs for part \#696, used in two of Walker's products. Mary has purchase cost and quantity data for the past 9 months_as follows:- (Click the icon to view the data for the past 9 months.) Estimated monthly purchases for this part based on expected demand of the tv (Click the icon to view the expected demand for the rest of the year.) Data table Data table Mary grabs Requirement 3. After a few hours Mary's computer is fixed. Mary uses the first and purchase costs of part \#696. The regression line Mary obtains is as follows Mary Sendler is the new manager of the materials storeroom for Walker Manufacturing. Mary has been asked to estimate future monthly purchase costs for part \#696, used in two of Walker's products. Mary has purchase cost and quantity data for the past 9 months as follows: (Click the icon to view the data for the past 9 months.) Estimated monthly purchases for this part based on expected demand of the two products for the rest of the year are as follows: (Click the icon to view the expected demand for the rest of the year.) Read the requirements. Requirement 1. The computer in Mary's office is down, and Mary has been asked to immediately provide an equation to estimate the future purchase cost for part \#696. Mary grabs a calculator and uses the high-low method to estimate a cost equation. What equation does she get? =+(1 Requirement 2. Using the equation from requirement 1, calculate the future expected purchase costs for each of the last 3 months of the year. Requirement 3. After a few hours Mary's computer is fixed. Mary uses the first 9 months of data and regression analysis to estimate the relationship between the quantity purchased and purchase costs of part \#696. The regression line Mary obtains is as follows: y=$2,054.4+3.69X Requirement 3. After a few hours Mary's computer is fixed. Mary uses the first 9 months of data and regression analysis to estimate the relationship between the quantity purchased and purchase costs of part \#696. The regression line Mary obtains is as follows: y=$2,054.4+3.69X Run a regression on the 9 months of data using Microsoft Excel to determine the R Square and t Stat for the X Variable 1 statistics. (Enter the R Square and t Stat amounts to six decimal places, 0.XXXXXX