At a minimum, you need one quantitative (numerical) variable and one qualitative (categorical) variable (with at least
Question:
At a minimum, you need one quantitative (numerical) variable and one qualitative (categorical) variable (with at least two levels). Get some data from the source of your choice (at least two columns to compare, with at least 15 data entries per column).
For example, you might decide to compare the Yankees and the Red Sox for the last 20 years; team is the qualitative variable, the quantitative variable might be the total number of home runs hit per year. Which term is better? (We Yankee fans will say “Yankees”, but get the data!). Some other examples:
- Baseball: Compare teams (categorical variable) [e.g., National League team vs. American League team]; Compare total runs batted in (RBIs) or total home runs (HR); use data from the last 30 years. (Look at www.mlb.com for major league baseball info.)
- Baseball: Compare two players over their lifetime: Examine Hits or RBIs.
- Football: Compare two teams on Win % or Total Yards Gained for a season.
- Stock market: Compare two stocks on selling price or profit ratio monthly for two years.
- Weather: Compare the daily highs or lows for a month for two locations.
As part of the introduction to your report, discuss what you selected and where you got the data. See the outline of the project report (next page).
Using EXCEL or software of your choice, create appropriate graphs (histogram, bar graph, pie chart) to describe your data. Be sure to write a summary describing what you can conclude from the graphical analysis. Continue your project by determining the summary statistics (mean, median, mode standard deviation etc). Be sure to include this information in your project write-up and discuss what you can conclude. Be sure to mention any outliers. Can you think of any reasons for their existence? What might be confounding or lurking variables? Be sure to include this information in your discussion/conclusion. Using Excel, or by hand create the frequency distributions for each group (column) using the same boundaries, class limits and midpoints. (may have to add or delete rows)
Lower Boundary | Lower Class Limit | Midpoint | Upper Class Limit | Upper Boundary | Group 1 Frequency | Group 1 Percent | Group 2 Frequency | Group 2 Percent |
Statistics for Business and Economics
ISBN: 978-0321826237
12th edition
Authors: James T. McClave, P. George Benson, Terry T Sincich