STAT 3000 Fall 2000 Data Presentation & Descriptive Statistics Exercise, Papers of Statistics

A computer exercise for stat 3000 students in the fall 2000 semester. The exercise covers data presentation and descriptive statistics using microsoft excel and statlets. Students are required to complete various tasks, such as creating bar charts, pie charts, histograms, and obtaining descriptive statistics for given variables.

Typology: Papers

Pre 2010

Uploaded on 07/30/2009

koofers-user-en4
koofers-user-en4 🇺🇸

10 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
STAT 3000
Fall 2000
Computer exercise I
Data Presentation & Descriptive Statistics
Due: Monday, October 2, 2000
Points: 75
The purpose of this computer exercise is to make you familiar with computer-based
statistical data analysis. This exercise will introduce you to exploratory data analysis
using Microsoft Excel and the Web-based statistical package Statlets.
You have to complete the exercise using a computer and turn in an original printout. The
printout should be concise and contain computer-generated graphs and tables. The
printout should be carefully annotated (all graphs and tables must be numbered - either by
hand or typed). Additional comments and explanations should be provided on a separate
sheet of paper (either by hand or typed). In order to reduce the number of pages to print,
it might be useful to import or copy graphs and tables into a text processor (such as
Microsoft Word) where you can edit them, e.g., adjust their size so that more than one
graph and/or table fit on one page.
References:
To complete this exercise, you will have to consult the following sources of information:
- Computer lab manual (handout, also
http://www.math.usu.edu/~vukasino/teaching/fall2000/complab/manual1_001.PDF)
- Microsoft Excel help sheet (handout, also
http://www.math.usu.edu/~vukasino/teaching/fall2000/complab/excel_help.PDF)
- Statlets Manual (http://www.statlets.com/usermanual/index.htm)
Grading criteria:
The maximum number of points for this exercise is 75. The following components will
be considered when grading your exercises:
Correctness of graphs and calculations 30%
Labeling 20%
Overall appearance and technical quality 30%
Explanations and comments (where applicable) 20%
You can work on this exercise individually or in groups of max. 3 students. If you
work in groups, make sure that the names of all group members are listed on the printout.
It will be assumed that all members have contributed equally to the final outcome of the
exercises. All members will be given the same number of points.
pf2

Partial preview of the text

Download STAT 3000 Fall 2000 Data Presentation & Descriptive Statistics Exercise and more Papers Statistics in PDF only on Docsity!

STAT 3000

Fall 2000

Computer exercise I

Data Presentation & Descriptive Statistics

Due: Monday, October 2, 2000 Points: 75

The purpose of this computer exercise is to make you familiar with computer-based statistical data analysis. This exercise will introduce you to exploratory data analysis using Microsoft Excel and the Web-based statistical package Statlets.

You have to complete the exercise using a computer and turn in an original printout. The printout should be concise and contain computer-generated graphs and tables. The printout should be carefully annotated (all graphs and tables must be numbered - either by hand or typed). Additional comments and explanations should be provided on a separate sheet of paper (either by hand or typed). In order to reduce the number of pages to print, it might be useful to import or copy graphs and tables into a text processor (such as Microsoft Word) where you can edit them, e.g., adjust their size so that more than one graph and/or table fit on one page.

References:

To complete this exercise, you will have to consult the following sources of information:

  • Computer lab manual (handout, also http://www.math.usu.edu/~vukasino/teaching/fall2000/complab/manual1_001.PDF )
  • Microsoft Excel help sheet (handout, also http://www.math.usu.edu/~vukasino/teaching/fall2000/complab/excel_help.PDF )
  • Statlets Manual (http://www.statlets.com/usermanual/index.htm)

Grading criteria:

The maximum number of points for this exercise is 75. The following components will be considered when grading your exercises:

Correctness of graphs and calculations 30% Labeling 20% Overall appearance and technical quality 30% Explanations and comments (where applicable) 20%

You can work on this exercise individually or in groups of max. 3 students. If you work in groups, make sure that the names of all group members are listed on the printout. It will be assumed that all members have contributed equally to the final outcome of the exercises. All members will be given the same number of points.

Part I: Microsoft Excel (started on 09/08/2000 in class)

For this part of the exercise, you will use the student data set collected in class and available on the Web as Microsoft Excel file at http://www.math.usu.edu/~vukasino/teaching/fall2000/Data/student_data1.xls

  1. a) Construct a bar chart and a pie chart for the variable "Color of eyes". Explain briefly what information you can get from your graphs.
  2. b) Construct a histogram for the variable "Weight". Use 10 pounds wide intervals. Explain briefly what you can conclude from your histogram.
  3. c) Construct a histogram for the variable "Height". Choose interval width that will best show the distribution of the data. Explain briefly what you can conclude from this histogram.
  4. d) Obtain descriptive statistics for the variables "Weight" and "Height".
  5. e) Obtain Q 1 , Q 3 , and IQR for the variables "Weight" and "Height".

Part II: Statlets

In this exercise you will have to use a text version of the student data file, available at http://www.math.usu.edu/~vukasino/teaching/fall2000/Data/student_data1.txt

  1. a) Provide a summary of the data set "student_data1.txt".
  2. b) Create stem-and-leaf plots for the variables "Weight" and "Height".
  3. c) Create histograms for the variables "Weight" and "Height". For each variable choose the number of intervals that you consider best for the presentation of the distribution of this particular variable.
  4. d) Create box plots for the variables "Weight" and "Height". Explain briefly what information these box plots give you about the distribution of the data.
  5. e) Calculate mean, median, range, variance, standard deviation, Q 1 , Q 3 , IQR, skewness, kurtosis, and coefficient of variation for all numerical variables in the data set. Describe briefly what these numbers tell you about the distribution of each variable. Which variable shows the greatest spread in this data set?