$1.$ Take the data above and estimate $($using TREND$)$ the $2024,2025$ and $2026$ level of sales as determined by using the year as the independent variable.

$2.$ Create a graph of Years and Sales for the years $2017$ to $2023$

$3.$ Insert a trend line, the trendline equation, R$^2$ and three period projections into the graph $|4.$ Copy this worksheet

$15.$On this "new" worksheet use the estimates of Sales for years $2024,2025$ and $2026$ to estimate COGS using TREND

$6.$ Graph Sales and COGS for the years $2017$ to $2023$

$7.$ Enter a trendline, the equation and R$^2$ of this trendline in the graph

$8.$Use liner regression to estimate the varameters of the relationshin between Sales and COGS

$9.$Use the intercept and coefficient of the linear regression to estimate COGS in $2024.$