• 100% Satisfaction Guarantee
Mr. Gregory White, Master's Degree
Category: Math Homework
Satisfied Customers: 92
Experience:  M.A., M.S. Education / Educational Administration
46856550
Type Your Math Homework Question Here...
Mr. Gregory White is online now

# Create a Microsoft Excel spreadsheet with the two variables

### Customer Question

Create a Microsoft Excel spreadsheet with the two variables from your learning team's dataset. Analyze the data with Microsoft Excel or other statistical tool(s), including: Descriptive stats for each numeric variable Histogram for each numeric variable
Bar chart for each attribute (non numeric) variable Scatter plot if the data contains two numeric variables Year Population Income Unemp GasPrice Van/SUV/Large SmallSUV Medium Small Hybrid 1990 248,709,873 38446 5.6 1.299 13.6 51.1 28.9 5.3 1.2 1991 252,153,092
37314 6.8 1.098 14.7 50.4 27.3 5.9 1.7 1992 255,029,699 36965 7.5 1.087 12 57.5 22.8 5.1 2.6 1993 257,782,608 36746 6.9 1.067 13.2 53.4 25.5 5.5 2.4 1994 260,327,021 37136 6.1 1.072 16.2 52.1 24.6 4.9 2.2 1995 262,803,276 38262 5.6 1.103 13.5 52.6 25.8 7.1
0.9 1996 265,228,572 38798 5.4 1.192 10.5 62.2 21.5 5.1 0.7 1997 267,783,607 39594 4.9 1.189 11 59.7 25.2 3.7 0.4 1998 270,248,003 41032 4.5 1.017 10 59.4 26.8 3.4 0.4 1999 272,690,813 42187 4.2 1.116 10 65.6 22.6 1.6 0.2 2000 281,421,906 42148 4 1.462 9.2
69.8 19 1.6 0.5 2001 285,226,284 42900 4.7 1.384 11.8 60.7 19.9 7 0.4 2002 288,125,973 42409 5.8 1.313 10.2 65.8 17.5 5.9 0.6 2003 290,796,023 43318 6 1.516 10.8 60.1 24.1 4.1 0.8 2004 293,638,158 44389 5.5 1.812 13.2 56.3 27.2 2.2 1.1 2005 296,507,061 47845
5.1 2.24 13.7 47.7 30.3 6.4 1.9 2006 299,398,484 48201 4.8 2.533 14.7 49.8 25.1 8.9 1.5 2007 303,162,947 48557 4.6 2.7 16 46.8 29.3 5.7 2.3
Submitted: 1 year ago.
Category: Math Homework
Expert:  Ray Atkinson replied 1 year ago.

Which two variables are you using? Your file has ten.