These are steps adding onto the assignment above. Please give me a step by step guide on how to solve this steps on excel, please include specific tools to be used and where they are located. $11$ Calculating the correlation coefficient is useful to determine the type and strength of a relationship between two variables. However, in business, there may be several independent variables that affect a dependent variable. For example, age of customers may not be the only variable that has a relationship with revenue; age and income could also be factors.

In cell E$2,$ determine the correlation between the data in cells A$2$:A$37$ and B$2$:B$37.5$

$12$ Correlation coefficient values are easy to interpret, but it is often more powerful to create a chart that illustrates that relationship visually.

Visualize the relationship in the data using a scatter chart. Create the chart using the data in A$1$:B$37.$ Add a Linear Trendline and add a Vertical Axis title using the text Sales Revenue. Add a Horizontal Axis title using the text Age. Edit the chart title to read Sales$-$Age Correlation. Move the chart into the cell range D$4$:J$17,$ with the borders of the chart just inside the cells' borders. $16$

$13$ On the CorrelationMatrix worksheet, create a correlation matrix of three different variables. You have been given a random sample of customer data with whether a coupon was used, the amount of money spent on a given visit to the spa, and the client$$s age. Two of the coupon categories$$Yes and No$$are provided in the data set. The coupon variable must first be converted to numerical nominal data,

Yes $=1$ and No $=2,$ using an IF function.

In cell B$2,$ use an IF function to show a $1$ for Yes and a $2$ for No$.$ Copy the function down to cell B$37.$ Use the Data Analysis add$-$in to create a correlation table using the data in B$1$:D$37.$ Group the data by Columns and use the Labels in First Row option. Use cell F$1$ for the Output Range. Adjust the columns to be able to view the contents. $10$

$14$ Regression analysis is a method used to predict future values by analyzing the relationships between two or more variables. Excel$$s Data Analysis add$-$in provides an easy way to conduct a regression analysis on two or more variables.

On the Regression worksheet, use the Data Analysis add$-$in to create a regression analysis. Use cells C$1$:C$37$ as the Input Y Range. Use cells A$1$:B$37$ as the Input X Range. Click the Labels check box and use cell E$10$ as the Output Range. Adjust the columns as necessary so that all values are visible in the SUMMARY OUTPUT. $9$

$15$ In cell G$3,$ create a regression equation for the combination of age and coupon in cells E$3$ and F$3$ respectively. Copy the formula to down to G$6.4$

$16$ The FORECAST.ETS function uses a process to take existing data and make predictions based on existing patterns within the data.

On the Forecast worksheet, click or select cell C$16,$ and then type or enter $=$B$16.$ In cell C$17,$ forecast the sales revenue for the years $2026-2027$ based on the historical data from $2025.$ Copy cell C$17$ to C$18$:C$40.$ Format the cells C$16$:C$40$ as Currency. $4$

$17$ Save the workbook, exit Excel, and then submit your file as directed.