Data Presentation and Descriptive Statistics Exercise for STAT 3000, Fall 2001, Papers of Statistics

A computer exercise for stat 3000 students in the fall 2001 semester. The exercise focuses on data presentation and descriptive statistics using microsoft excel. Students are required to complete the exercise individually or in groups, and submit an original printout with computer-generated graphs, tables, and explanations. The exercise covers creating bar charts, pie charts, histograms, and obtaining descriptive statistics and quartiles for the variables 'weight' and 'height' from the student data set.

Typology: Papers

Pre 2010

Uploaded on 07/30/2009

koofers-user-80c
koofers-user-80c 🇺🇸

10 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
STAT 3000 Section 003
Fall 2001
Computer exercise I
Data Presentation & Descriptive Statistics
Due: Thursday, September 20, 2001 Name(s):
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.
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/fall2001/complab/manual1.PDF)
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. 4 students. If you
work in groups, make sure that the names of all group members are listed on the printout.
Please turn in only one printout per group. 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 Data Presentation and Descriptive Statistics Exercise for STAT 3000, Fall 2001 and more Papers Statistics in PDF only on Docsity!

STAT 3000 Section 003 Fall 2001

Computer exercise I

Data Presentation & Descriptive Statistics

**Due: Thursday, September 20, 2001 Name(s): 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.

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/fall2001/complab/manual1.PDF)

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. 4 students. If you work in groups, make sure that the names of all group members are listed on the printout. Please turn in only one printout per group. 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.

Exercise 1 (started on 09/13/2001 in class)

For this 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/fall2001/Data/student_data3.xls

  1. 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. Construct a histogram for the variable "Weight". Use 20 pounds wide intervals. Explain briefly what you can conclude from your histogram.
  3. 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. Obtain descriptive statistics for the variables "Weight" and "Height".
  5. Obtain Q 1 , Q 3 , and IQR for the variables "Weight" and "Height".