An Excel spreadsheet is attached including 30 data sets, each of which represent

No Comments

Photo of author

By admin

An Excel spreadsheet is attached including 30 data sets, each of which represents a SAMPLE of 50 observations from the larger LEGO Dataset that we used last week. You have been assigned a data set number (see READ THIS FIRST) to use for your post. Once you have found your tab (Student XX), export the data for your worksheet to CSV (comma-separated values) format.
NOTE: DO NOT use the Big LEGO Dataset from last week for this discussion. Your data should have only 50 observations. See below.

Open Statkey (https://www.lock5stat.com/StatKey/index.html) in any browser and click on One Quantitative Variable. Click UPLOAD FILE and upload the CSV file you created above. Choose the Current_Price variable and display the Histogram (click on Histogram tab).
Video (One Quantitative Variable): https://youtu.be/lrW2z4xbPWU
NOTE: Statkey only allows uploads of .CSV files, be sure to Export the Excel file in Step 1 to a Comma-Separated-Value (.CSV) format.

Take a screenshot of your histogram as well as the Summary Statistics and Save this as a .JPG (or other picture format) so you can include this in your discussion post. For example:

Interpret the graphical (histogram) and numerical (Summary Statistics) information for your sample.

Instructions for Initial posts:
For the title of your post use your last name and the data set that you selected (Example: Smith – Data Set #51).
First post the screenshot of your Statkey results. Use the “Insert Image” (two mountains on a dark rectangle) to insert your picture into your post.

Be sure to include your individual CSV data file as an Attachment (click “Add Attachment”).

Report the measures of center (mean, median) for your sample. Explain what these numbers mean about this data. Are they the same? Why are they different?

What is the standard deviation? What does this tell you about the data?

What are your observations from the histogram? What do you notice about this data visualization? Is the distribution symmetric or skewed? If skewed, is it skewed to the right or the left? How does this help you understand the data regarding the prices of LEGO sets?

Leave a Comment