{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# EX_all - EXCEL-lent Descriptive Statistics Major U.S...

This preview shows pages 1–4. Sign up to view the full content.

EXCEL-lent!!! --- Descriptive Statistics Major U.S. Airport Traffic Statistics The following data represent levels of traffic among the N =135 airports that are classified as medium or large hubs by the Federal Aviation Administration (FAA). The variables included are: Airport – Column A (Nominal) City – Column B (Nominal) Scheduled Departures – Column C (Interval) Performed Departures – Column D (Interval) Enplaned Passengers – Column E (Interval) Enplaned Revenue Tons of Freight – Column F (Interval) Enplaned Revenue Tons of Mail – Column G (Interval) Obtain all relevant (and some irrelevant) summary statistics using EXCEL , by following these directions: Click on usair2.xls Choose Descriptive Statistics by selecting: Tools Data Analysis Descriptive Statistics 4) Input data range \$C\$1:\$G\$136 (The columns represent the interval scale variables measured on each airport) Grouped by Columns Click on Labels (variable names are given in row 1) Click on Summary Statistics (this will compute many statistics that would take a real long time to do by hand) Click on OK (the output will be printed to another worksheet, unless you change the output option) Print out the worksheet that contains the summary statistics.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Obtain a histogram (and frequency distribution) for the variable Enplaned Passengers by following these directions (make obvious changes to repeat for any other interval scale variable). Click on usair2.xls Choose Histogram by selecting: Tools Data Analysis Histogram 4) Input data range \$E\$1:\$E\$136 (This column represent the interval scale variable Enplaned Passengers Click on Labels (variable names are given in row 1) Click on Chart Output (expand plot by clicking on plot then “stretching” from corner). Print out the worksheet that contains the frequency distribution and expanded histogram. Source: U.S. Federal Aviation Administration and Research and Special Programs Administration, Airport Activity Statistics (1990).
EXCEL-lent!!! – 2 Independent Samples Household Incomes for FL and NC Mall Target  Populations  A small retailer is interested in determining whether household incomes differ by geographic area. She selects 12 Florida malls and 9 North Carolina malls at random, and observes the average household income for each mall’s target population. Suppose she wishes to determine whether malls’ target populations differ with respect to mean income between FL and NC. Conduct the independent-sample t -test using EXCEL , by following these directions: Click on mall.xls Choose independent sample t -test by selecting: Tools Data Analysis t -test: 2-Sample Assuming Equal Variances Input data range \$C\$1:\$C\$13 for Variable 1 (The column represent FL, there are 12 malls of data) Input data range \$D\$1:\$D\$10 for Variable 2 (The column represent NC, there are 9 malls of data) Choose

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 11

EX_all - EXCEL-lent Descriptive Statistics Major U.S...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online