New Castle County Technical Services (NCCTS) provides technical support services for a number of companies in New Castle County, Delaware. Previously, you created an amortization schedule to detail payment and interest information on a $65,000 facility upgrade. NCCTS has kept the historical financial data regarding their past facility upgrades and you want to use this informa-tion to predict the cost of the next upgrade in five years. You will add a linear trendline to a scatter plot chart, as well as use the FORECAST function to complete your calculations. You will also use statistical functions to verify the results of the linear trendline.

a. Open e08r1NCCTS and save it as e08r1NCCTS_LastFirst.

b. Create a Scatter Plot on the Historical_Data worksheet that displays the purchase date on the X axis and the Cost on the Y axis.

c. Add a linear trendline to the chart, display the R-squared value and equation.

d. Add an appropriate chart title.

e. Insert a function in cell E5 to calculate the INTERCEPT of the trendline.

f. Insert a function in cell F5 to calculate the SLOPE of the trendline.

g. Insert a function in cell G5 to calculate the R-squared value of the trendline.

h. Insert a function in cell H5 to calculate the Standard Error.

i. Use the FORECAST.LINEAR function to calculate the estimated cost of equipment upgrades in cell F8. The prediction should be based on the year 2025. Format the results as currency.

j. Use the standard error calculated in cell H5 to determine the high and low thresholds in the range G8:H8. Ensure the results are displayed as currency.

k. Use the linear equation (y = mx + b) in cell E11 to manually check your work. Ensure the results are displayed as currency.

l. Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side. m. Save and close the workbook. Based on your instructor’s directions, submit e08r1NCCTS_LastFirst.

New Castle County Technical Services (NCCTS) provides technical support services for a number of companies in New Castle County, Delaware. Previously, you created an amortization schedule to detail payment and interest information on a $65,000 facility upgrade. NCCTS has kept the historical financial data regarding their past facility upgrades and you want to use this informa-tion to predict the cost of the next upgrade in five years. You will add a linear trendline to a scatter plot chart, as well as use the FORECAST function to complete your calculations. You will also use statistical functions to verify the results of the linear trendline.

a. Open e08r1NCCTS and save it as e08r1NCCTS_LastFirst.

b. Create a Scatter Plot on the Historical_Data worksheet that displays the purchase date on the X axis and the Cost on the Y axis.

c. Add a linear trendline to the chart, display the R-squared value and equation.

d. Add an appropriate chart title.

e. Insert a function in cell E5 to calculate the INTERCEPT of the trendline.

f. Insert a function in cell F5 to calculate the SLOPE of the trendline.

g. Insert a function in cell G5 to calculate the R-squared value of the trendline.

h. Insert a function in cell H5 to calculate the Standard Error.

i. Use the FORECAST.LINEAR function to calculate the estimated cost of equipment upgrades in cell F8. The prediction should be based on the year 2025. Format the results as currency.

j. Use the standard error calculated in cell H5 to determine the high and low thresholds in the range G8:H8. Ensure the results are displayed as currency.

k. Use the linear equation (y = mx + b) in cell E11 to manually check your work. Ensure the results are displayed as currency.

l. Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side. m. Save and close the workbook. Based on your instructor’s directions, submit e08r1NCCTS_LastFirst.

New Castle County Technical Services (NCCTS) provides technical support services for a number of companies in New Castle County, Delaware. Previously, you created an amortization schedule to detail payment and interest information on a $65,000 facility upgrade. NCCTS has kept the historical financial data regarding their past facility upgrades and you want to use this informa-tion to predict the cost of the next upgrade in five years. You will add a linear trendline to a scatter plot chart, as well as use the FORECAST function to complete your calculations. You will also use statistical functions to verify the results of the linear trendline.

a. Open e08r1NCCTS and save it as e08r1NCCTS_LastFirst.

b. Create a Scatter Plot on the Historical_Data worksheet that displays the purchase date on the X axis and the Cost on the Y axis.

c. Add a linear trendline to the chart, display the R-squared value and equation.

d. Add an appropriate chart title.

e. Insert a function in cell E5 to calculate the INTERCEPT of the trendline.

f. Insert a function in cell F5 to calculate the SLOPE of the trendline.

g. Insert a function in cell G5 to calculate the R-squared value of the trendline.

h. Insert a function in cell H5 to calculate the Standard Error.

i. Use the FORECAST.LINEAR function to calculate the estimated cost of equipment upgrades in cell F8. The prediction should be based on the year 2025. Format the results as currency.

j. Use the standard error calculated in cell H5 to determine the high and low thresholds in the range G8:H8. Ensure the results are displayed as currency.

k. Use the linear equation (y = mx + b) in cell E11 to manually check your work. Ensure the results are displayed as currency.

l. Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side. m. Save and close the workbook. Based on your instructor’s directions, submit e08r1NCCTS_LastFirst.

a. Open e08r1NCCTS and save it as e08r1NCCTS_LastFirst.

a. Open e08r1NCCTS and save it as e08r1NCCTS_LastFirst.

c. Add a linear trendline to the chart, display the R-squared value and equation.

c. Add a linear trendline to the chart, display the R-squared value and equation.

d. Add an appropriate chart title.

d. Add an appropriate chart title.

e. Insert a function in cell E5 to calculate the INTERCEPT of the trendline.

e. Insert a function in cell E5 to calculate the INTERCEPT of the trendline.

f. Insert a function in cell F5 to calculate the SLOPE of the trendline.

f. Insert a function in cell F5 to calculate the SLOPE of the trendline.

g. Insert a function in cell G5 to calculate the R-squared value of the trendline.

g. Insert a function in cell G5 to calculate the R-squared value of the trendline.

h. Insert a function in cell H5 to calculate the Standard Error.

h. Insert a function in cell H5 to calculate the Standard Error.