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, Target or Walmart and gather the name and price of 10 grocery items from a national maker. (Make up your own reasonable 10 prices)
Column E: Visit an online retailer such as Amazon and gather the name and price of the exact same 10 grocery items selected at brick and mortar retailer. (Make up your own reasonable 10 prices)
Column F: Select 10 male friends and enter their ages. (20, 21, 24, 21, 20, 22, 28, 27, 23, 28)
Column G: Select 10 female friends and enter their ages. (24, 29, 20, 22, 21, 27, 20, 26, 27, 21)
Column H: Gather the GDP data of your country of Origin for the past 10 years. (Saudi Arabia)
Column I: Gather the GDP data of a country other than USA or your country of origin for the last 10 years. (Italy)
Column J: Gather the GDP data of the USA for the last 10 years.
Guidance: GDP data is available at this web site; https://data.worldbank.org/indicator/ny.gdp.mktp.kd.zg (Links to an external site.)Links to an external site.
For the GDP website, simply enter the name of the country and use the cursor to gather the data. Note: some countries will not have a reporting convention. If your country or origin or your selected country does not have this information, simply select another location of interest.
Finally, document all the data collected beginning in column J. Clearly provide the detail that allows a person looking at your data set to understand all the variables and all the information that is present.
Once you are done with the Excel file, answer the following questions. Remember to provide evidence and screenshots of the analysis embedded in the results.
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.