Question
(1) Using StatCrunch and the Online Seller Data provided on Blackboard, find and report the following summary statistics, representing both measures of center (e.g., mean
(1) Using StatCrunch and the Online Seller Data provided on Blackboard, find and report the following summary statistics, representing both measures of center (e.g., mean and median) and measures of variation/spread (e.g., standard deviation and range): (i) The mean and median for Amazon.com product prices. (ii) The mean and median for Walmart.com product prices. (iii) The standard deviation and range for Amazon.com product prices. (iv) The standard deviation and range for Walmart.com product prices.
(2) Using the StatCrunch results obtained in Part (1), state initial/preliminary conclusions that could be made in two to four complete sentences.
(3) Using StatCrunch and the Online Seller Data provided on Blackboard, create a statistical graph that can be used to compare the product prices for Amazon.com and Walmart.com. (i) Provide the statistical graph(s) created. (ii) In two to four complete sentences, state initial/preliminary conclusions that could be made. *Note: Any conclusions made up to this point have been initial and do not suggest statistical significance yet, as no formal statistical testing or other inferential procedure such as confidence interval estimation has been performed. You will need to move beyond summary statistics and beyond visualizations for Part (4) below!
(4) One research question that could be posed using the available data: Do product prices differ significantly between Amazon.com and Walmart.com and, if so, by how much? Determine a method that would be appropriate for answering this research question. Using StatCrunch and the available data, perform the statistical procedure deemed appropriate. Hint: You will need to go beyond the exploratory data analysis (i.e., summary statistics and visualizations) in Questions 1-3 above. (i) What method did you use to answer the research question e.g., One-Sample t-Test for Means? (ii) Why did you select this particular method to answer the research question? (iii) In one to two complete sentences, summarize and interpret the relevant findings of your analysis in the context of the research question i.e., what do the findings suggest about the impact of online retailer on product prices? (iv) Consider and, then, suggest how you would approach data collection in the future if you were interested in comparing Amazon.com and Walmart.com product prices for one particular market sector/category within online sales (e.g., Grocery/Cosmetic) during fall 2020.
Product | Category | Amazon | WalMart |
Nespresso Pixie D60 Espresso Machine | Kitchen/Housewares | 242.05 | 225.99 |
NatureMade Super B-Complex (460) | Grocery/Cosmetic | 17.49 | 19.97 |
Crocs - Mens Classic | Clothing/Shoes | 32.95 | 25.95 |
Altra Women's Superior 2 Trail | Clothing/Shoes | 85.19 | 82.94 |
Tracfone 60MIN Card | Grocery/Cosmetic | 24.95 | 19.99 |
Pero 7OZ | Grocery/Cosmetic | 5.98 | 5.98 |
3-Way Gourmet Popcorn | Grocery/Cosmetic | 49.99 | 31.27 |
Marmot Mens Zeus Jacket 2XL | Clothing/Shoes | 120 | 126 |
Nectar in a Sieve | Miscellaneous | 6.49 | 7.77 |
The Essential Yo-Yo Ma | Miscellaneous | 13.98 | 14.75 |
DHP Emily Futon, Vanilla | Kitchen/Housewares | 172.79 | 189 |
Huffy Nel Lusso Cruiser, Yellow | Miscellaneous | 156.79 | 119 |
Celestial Tea, Assorted, 150 CT | Grocery/Cosmetic | 28.52 | 27.98 |
Venus Swirl Razor, 2 Blade Refills | Grocery/Cosmetic | 11.75 | 12.97 |
TI-30X IIS Scientific Calculator | Miscellaneous | 12.95 | 12.95 |
Fitbit Blaze, Black | Miscellaneous | 169 | 199.95 |
Pampers Easy Ups, 3T/4T, 148CT | Grocery/Cosmetic | 41.25 | 43.51 |
Better Homes & Gardens 6-PC Towels | Kitchen/Housewares | 27.62 | 15.49 |
Zoey Contemporary Display Shelf, Red | Kitchen/Housewares | 320.17 | 437.98 |
Maglite LED Flashlight | Miscellaneous | 25.47 | 38.99 |
Vera Wang Champagne Flutes | Kitchen/Housewares | 124.99 | 125 |
Goodyear Wrangler Tire, 235/75R15 105S | Miscellaneous | 74 | 126.99 |
Everest Fanny Waist Pack | Clothing/Shoes | 5.9 | 9.99 |
Ravel Paris Bb Trumpet | Miscellaneous | 381 | 419.28 |
Peanut M&Ms, 42OZ | Grocery/Cosmetic | 8.54 | 8.98 |
KODAK PIXPRO FZ53 Compact Digital Camera | Miscellaneous | 77 | 77 |
Gold's Gym Vinyl Weight Set, 100 lbs | Miscellaneous | 72 | 60 |
Fruit of the Loom Mens No-Show Socks, 6 Pack | Clothing/Shoes | 6.57 | 7.47 |
Speedo Vanquisher 2.0 Mirrored Swim Swimming Competition Goggle, Silver/Blue | Miscellaneous | 18.02 | 17.65 |
Wilson Thrasher Racquetball Racquet | Miscellaneous | 49.95 | 69.95 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started