Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

STAT 280 Spring 2006 Lab 1: Analyzing Cheddar Cheese Data with Excel, Lab Reports of Statistics

Rice UniversityStatistics

Lab 1 for stat 280 spring 2006 course, where students are required to analyze a dataset of cheddar cheese using excel. The tasks include creating histograms, calculating statistics, identifying outliers, and creating scatter plots. Students are also introduced to using excel's data analysis tool and statistical functions.

Typology: Lab Reports

Pre 2010

Uploaded on 08/30/2009

koofers-user-b8l
koofers-user-b8l ๐Ÿ‡บ๐Ÿ‡ธ

10 documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
STAT 280 spring 2006
Lab 1
Lab 1 is due at the end of your assigned lab to your TA. Your TA means the TA who is
instructing the lab you have registered for. Labs my be turned in to your TAโ€™s mailbox
located in DH 1092 or handed in to him/her in person after the lab. E-mail submissions
are not accepted.
Labs are to be written up in legible reports with all graphs labeled. It is possible to insert
graphs and spreadsheets into a Microsoft word document.
The file name of the data is DataSet1.XLS available on the courses website. This data
set is also on the CD found attached to the back cover of your textbook. On the CD this
data is called CHEESE.XLS. In the CD Drive, click the PCDataSets folder, then the
Excel folder, then the Appendix folder, and you will see the CHEESE.XLS file.
Double-click to open this file in Excel. An explanation of this data set can be found in
the Data Appendix of the text, page D-1 (of the fourth edition).
You will also need to make sure the Analysis ToolPak add-in is installed on Excel. In
Excel, go to Tools ๏ƒ  Add-Ins and make sure Analysis ToolPak is checked and click
Ok. If it is already checked, click Cancel.
Codebook [i.e. what the columns mean in the data set]
1. Case โ€“ this is the number of observations of cheddar cheese labeled from 1 to 30.
2. Taste โ€“ the combined taste score of several tasters.
3. Acetic โ€“ the natural log of the concentration of acetic acid in the observation
4. H2S โ€“ the natural log of the concentration of hydrogen sulfide in the observation
5. Lactic โ€“ the concentration of lactic acid in the observation.
Note: For the purposes of this lab, do not be concerned with the natural log
transformation of the Acetic and H2S variables. Just use the data given on the
spreadsheet.
Objective
The purpose of this lab is to familiarize you with data sets and basic excel functions.
Much of what you learn in this lab will be need in future labs, and can help you with
homework assignments.
Tasks
1. Plot a histogram of the Taste, Acetic, H2S, and Lactic data, each on separate graphs.
pf3

Partial preview of the text

Download STAT 280 Spring 2006 Lab 1: Analyzing Cheddar Cheese Data with Excel and more Lab Reports Statistics in PDF only on Docsity!

STAT 280 spring 2006

Lab 1

Lab 1 is due at the end of your assigned lab to your TA. Your TA means the TA who is instructing the lab you have registered for. Labs my be turned in to your TAโ€™s mailbox located in DH 1092 or handed in to him/her in person after the lab. E-mail submissions are not accepted. Labs are to be written up in legible reports with all graphs labeled. It is possible to insert graphs and spreadsheets into a Microsoft word document. The file name of the data is DataSet1.XLS available on the courses website. This data set is also on the CD found attached to the back cover of your textbook. On the CD this data is called CHEESE.XLS. In the CD Drive, click the PCDataSets folder, then the Excel folder, then the Appendix folder, and you will see the CHEESE.XLS file. Double-click to open this file in Excel. An explanation of this data set can be found in the Data Appendix of the text, page D-1 (of the fourth edition). You will also need to make sure the Analysis ToolPak add-in is installed on Excel. In Excel, go to Tools ๏ƒ  Add-Ins and make sure Analysis ToolPak is checked and click Ok. If it is already checked, click Cancel. Codebook [i.e. what the columns mean in the data set]

  1. Case โ€“ this is the number of observations of cheddar cheese labeled from 1 to 30.
  2. Taste โ€“ the combined taste score of several tasters.
  3. Acetic โ€“ the natural log of the concentration of acetic acid in the observation
  4. H2S โ€“ the natural log of the concentration of hydrogen sulfide in the observation
  5. Lactic โ€“ the concentration of lactic acid in the observation. Note: For the purposes of this lab, do not be concerned with the natural log transformation of the Acetic and H2S variables. Just use the data given on the spreadsheet. Objective The purpose of this lab is to familiarize you with data sets and basic excel functions. Much of what you learn in this lab will be need in future labs, and can help you with homework assignments. Tasks
  6. Plot a histogram of the Taste, Acetic, H2S, and Lactic data, each on separate graphs.

For each plot indicate if you think the histogram is symmetric, skewed left, or skewed right. Why are histograms useful in general?

  1. For the Taste, Acetic, H2S, and Lactic data, use excel to determine the mean, median, mode, standard deviation, range, 1st^ quartile, and 3rd^ quartile. How can you tell from these numbers alone if the distribution of the data is symmetric (or roughly symmetric)?
  2. On a single graph, create a box plot of the Taste, Acetic, H2S, and Lactic data. From these box plots, can you identify any outliers in the data? If there are outliers, what variable do they belong to and about how many are there per variable?
  3. Excel can also be used to calculate probabilities. a) Suppose Z has a Standard Normal Distribution. Find the following probabilities using excel: 1. Z < -2. 2. Z < 1. 3. Z > 2. Do each of these probabilities match what you would calculate using standard normal tables? If they do you know your using the Excel function correctly. b) Suppose the random variable X has a normal distribution with mean 24 and standard deviation 14. If we were to use tables to find the probabilities of this distribution, we would first have to transform X into a standard normal random variable (Z), then look the probabilities up on the standard normal tables. Excel, however, will automatically do the transformations for us. Find the following probabilities using excel. Convince yourself these are correct by transforming X into Z and using the tables from your textbook. 1. X < 18 2. X > 47
  4. Make scatter plots of Taste vs. Acetic, Taste vs. H2S, and Taste vs. Lactic. Make sure each graph has the x and y-axes labeled and a title. From looking at these three graphs, does any of Acetic, H2S, or Lactic have an evident relationship with Taste? What leads you to these conclusions? Tools
  5. To make a histogram, click on Tools ๏ƒ  Data Analysis. Select Histogram , and click Ok. Click and drag a box around the column of data you want to plot (the corresponding columns should appear in the Input Range box), and make sure the