(Solved) : Statistic And Excel . . .

Question Description

Before you begin the preparation, make sure that you have loaded the Data Analysis Toolpak in Excel.

Create the following spreadsheet:

Column A: Observations. Use numeric or text to identify them. For example, “OBS 1” or simply “1”.

Column B: The last 20 days of observed low temperatures in your home town. (Riyadh)

Column C: The last 20 days of observed low temperatures for the town you live in now. (Miami)

Guidance: These data are available through any weather service- simply request previous or historical data available when viewing the entire month.

Column D: Visit a brick-and-mortar retailer such as Publix,