The steps you will follow for this project are as follows

Download the Excel data file.

Click on the Video button on the bottom left or within the Get More Help menu for this question now. This tutorial video will walk you through this exercise, step$-$by$-$step

Perform the requirements on the data file.

Check your work in the Excel file with these check figures.

Use your Excel file to answer the four multiple choice questions below. $($You will have to scroll down to see all of the questions.$)$

Resources

A$)$ Information on how to update Excel and Office $365$

B$)$ If you do not have Office $365,$ click here to leam how to get it for free.

C$)$ Troubleshooting FAQ.

Using the Excel file you created for Daisy, what are the predicted product sales at $200$ media mentions?

A$.393\mathrm{.}1620$

O B$.409\mathrm{.}0240$

O C$.353\mathrm{.}5072$

D$.377\mathrm{.}3001$

Using the Excel file you created for Daisy, what are the predicted product sales at $250$ media mentions?

A$.409\mathrm{.}0240$

B$.393\mathrm{.}1620$

C$.377\mathrm{.}3001$

D$.353\mathrm{.}5072$

Using the Excel file you created for Daisy, how many quarts of frozen yogurt could Daisy's expect to sell if there were $375$ mentions of Daisy's frozen yogurt in news and social media in

A$.377\mathrm{.}3001$

B$.409\mathrm{.}0240$

C$.393\mathrm{.}1620$

D$.353\mathrm{.}5072$

Using the Excel file you created for Daisy, does it appear that the number of media mentions will be a good predictor of sales of frozen yogurt? How can you tell?