Project Assignment

Get perfect grades by consistently using www.customizedassignments.com. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

Create the following spreadsheet:

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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. ( Jeddah,Saudi Arabia )

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

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.

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.

Guidance: I suggest these be canned foods, bread, frozen foods- anything that is pre-processed and a national brand. I suggest that you select 15 items in case an item is not available in one place or the other. The items should be exactly the same items. Avoid the deli, bakery, meat and produce departments as these are internally prepared r seasonally available.

Column F: Select 10 male friends and enter their ages. ( Ghanim/26, Hussain/24 , Khaled/23 , Mohammed/25, Fahad/28, Melton/19, Ander/22, Nicholas/20, Pedro/21, John/23 ).

Column G: Select 10 female friends and enter their ages. ( Maria/23, Linda/21, Hana/22, Delisa/19, Allyn/22, Leslyn/21, Paola/23 , Lama/22, Anieliese/21, Verena/22 ).

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.

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, as we discussed in class.

Final Project Questions

  1. Is there a statistical difference in temperatures between your selected cities?
  2. Is there a statistical difference in age between your male and female friends?
  3. Is your age statistically different that your male friends?
  4. Is your age statistically different that your female friends?
  5. Are the prices of the online retailers statistically less expensive than their brick-and-mortar counterparts?
  6. Are the prices of the online retailers statistically different than their brick-and-mortar counterparts given that they are exactly the same products?
  7. Using 21 as a cut-off age, is there a relationship between the number of your friends over 21 and 21 and under with gender?
  8. Is there a relationship between the GDP data from the two countries?
  9. Does GDP of the USA have any bearing on the GDP of your country of origin of your first selected country?
  10. Does GDP of the USA have any bearing on the GDP of your country of origin of your second selected country?

When you have completed your analyses and clearly labelled all components and results and stated those results, submit your final Excel spreadsheet.

I need it in Excel so all the test that you are going to run on the data show the functions of each test

Writerbay.net

Hi, student! You are probably looking for a free essay here, right? The most obvious decision is to order an essay from one of our writers. It won’t be free, but we have an affordable pricing policy. In such a manner, you can get a well-written essay on any topic, and then can use it for citing, paraphrasing, or as a template for your paper. Let us cover any of your writing needs!


Order a Similar Paper Order a Different Paper