Using the appropriate tools (e.g., formulas, Excel, etc.), answer the three questions below. Show all work. Calculations and answers to questions can be on the same document. APA formatting is not required.A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were:DayNumber Sold136238342444548649750849952104811521255135414561557 Justify your selection of either a linear trend equation or trend-adjusted exponential smoothing to predict future sales.If you learn that on some days the store ran out of the specific pain reliever, would that knowledge cause you any concern? Explain.Assume that the data refer to demand rather than sales. Using trend-adjusted smoothing with an initial forecast of 50 for day 8, an initial trend estimate of 2, and α = β = .3, develop forecasts for days 9 through 16. What is the Mean Squared Error (MSE) for the eight forecasts for which there are actual data?

Overview:This project is intended to give you an opportunity to explore data visualization with Tableau, and work with a larger data set than is typical for textbook exercises. Using data the US Census’s American Community Survey (available to download from Canvas in module 1), you should use the data dictionary and both Excel and Tableau or Tableau Public to find an “interesting” story, that is to say a relationship in the data that you find interesting, amusing, frightening, or concerning.Assignment:Find two or more variables in a data set- I recommend the Census data if you don't have data of your own you want to investigate- that tell an interesting "story" (a data "story" is an interpretation of the data that explains or illuminates). Create a data visualization (or set of data visualizations) that illustrate this story. Your data visualizations might be as simple as scatter plots or more ambitious (geographical visualizations, animated charts). Complete this twice, once using Excel and once using Tableau Public. Make sure at least one of these graphs is very strong. Beneath your stronger graph, include a short paragraph reflecting on whether your graph follows the advice for graphs offered by your textbook (you may choose to ignore this advice, but if so you must acknowledge it and justify your different choice). You will then write a short (roughly ½ page) summary of your story. Include a title page, follow academic writing conventions and write in a professional tone, and save as a word document or .pdf file (do not split your projects across multiple files: graphs should be integrated with text inside the document).Data Note: Be careful about the "Person's Weight" variable. This does not mean "how much this person weighs" it means "how much weight to assign this person's answers." If you're curious (not required) you can read about statistical weighting here: http://www.applied-survey-methods.com/weight.html (Links to an external site.).Grade Note: Be sure to "check yourself" against the rubric below. Did you compare/contrast Excel vs. Tableau?