How do I Find these Results on excel?

Part 1: Descriptive Analysis For each of the following questions, it is your task to determine the type of scale for each variable, conduct the proper descriptive analysis with Excel, and interpret it: 1. What is the demographic composition of the sample? 2. How do respondents feel about concern for global warming? 3. What percent of Americans own an economy or standard automobile or luxury auto or truck? . X V fx income 3 K A B cartype plan warming gasem 5 5 5 4 1 3 4 4 3 3 4 mm 00 00 00 00 00 00 00 00 OOOOO NN 0 un 88 4 0 4 1 3 5 5 5 5 5 7 5 6 4 4 6 5 4 3 NWN 00 00 00 00 00 H D E F marital familysize age edcation income Thometype 0 3 1 1 55 125 1 3 8 45 0 88 3 1 1 3 35 8 125 1 0 1 2 45 6 63 1 1 1 35 8 88 1 0 1 2 45 125 3 1 1 3 35 3 8 0 1 4 45 8 125 2 1 1 3 35 8 125 1 0 1 3 55 10 175 2 1 1 45 8 125 1 1 1 3 35 8 125 2 0 D 1 45 6 63 3 0 1 2 45 6 63 4 1 0 1 35 8 88 1 1 1 4 35 8 125 1 0 0 1 45 8 88 1 1 1 2 35 6 63 2 1 1 2 88 3 1 1 3 35 8 125 2 0 1 2 55 8 125 1 1 3 45 6 63 1 1 2 65 6 88 3 1 2 65 4 63 1 0 1 55 4 63 3 1 2 35 6 88 2 D 1 45 4 63 3 0 1 2 65 6 88 3 1 1 3 35 8 88 1 0 1 2 55 6 88 4 1 1 4. 35 8 88 2 1 1 3 35 8 2 1 1 3 35 8 88 0 1 2 65 6 88 3 0 1 2 65 8 25 2 0 1 2 45 6 88 2 0 0 2 25 4 25 2 26 Auto Concepts Codebook + townsize gender 1250 300 55 300 300 7 750 8 300 9 55 10 55 11 300 12 750 13 300 14 750 15 750 16 750 17 55 18 750 19 750 20 750 21 750 22 1250 23 750 24 55 25 55 26 55 27 300 28 750 29 55 30 55 31 55 32 300 33 300 34 750 35 5 36 5 37 750 38 1250 20 ann 0 0 1 0 0 0 0 1 0 0 1 1 1 2 4 2 3 4 4 on 6 4 NN 5 35 6 2 1 6 3 4 1 4 WN NN + NN OOOOO NNN 1 4 NNN O 000 3 1 6 1 4 6 5 5 5 5 NMM 1 3 2 3 3 2 2. 3 2 4 How OOOOOOOOO 1 1 5 5 5 4 4 M NNNN NNNWN N 5 4 5 4 1 1 1 1 1 Ready Values 5 Under 10:55 - 10K to 100K: 300 - 100k to 500k; 750 - 500 Os male; 1 = female 0 - unmarried; 1 = married (Includes cohabitation) 6 1 Variable Name Label 2 townsize Size of home town or city gender Gender 4 marital Marital status 5 familysize Number of people in household Age 7 edcation Level of education B income Household income level 9 hometype Dwelling type 10 cartype Auto or truck type owned 11 plan Plan to purchase or lease a vehicle in the coming year 12 warming I am worried about global warming, 13 gasemit Gasoline emissions contribute to global warming 14 threat Global warming is a real threat. 15 conserve I drive conservatively to use less fuel 16 checktraffic I check traffic reports to avoid idling in traffic. 17 fue efficient I drive an automobile that is fuel efficient 18 supercycle seat Desirability: Super Cycle-1 Seat All-Electric Motorcycle 19 runaboutsport2seat Desirability: Runabout Sport - 2 Seat Al-Electric 20 runaboutstowage seat Desirability: Runabout with Stowage - 2 Seat Electric & Gasoline Hybrid 21 economyhybrid seat Desirability: Economy Hybrid - 4 Seat Electric & Gasoline Hybrid 22 economy asset Desirability: Economy Gasoline 4 Seat Economy Gasoline 23 lifestyle Life Style: Novelist 24 lifestylez Life Style: Innovator 25 lifestyle Life Style: Trendsetter 26 lifestyle Life Style: Forerunner 27 lifestyles Life Style: Mainstreamer 28 lifestyle Life Style: Classic 29 television Favorite television show type 30 radio Favorite radio genre 31 magazines Favorite magazine type 32 newspaper Favorite local newspaper section 33 blogs Use of online blogs 34 YouTube Use of content communities 35 Facebook Use of social network sites 36 Games Use of online games 17 Virtworld Use of virtual worlds 25 = 20-29;35 - 30 to 39:45 = 40 to 49;55 - 50 to 59,65 +60 0 = less than high school; 4 = high school graduate; 6 = some colle 25 - under $50k: 63 - $Sok to $75k; 88 - $76k to $100k, 1255 1 - single family, 2 multiple family, 3 - condominium/townhouse 1-none; 2 economy, 3 - standard; 4 - luxury 0no;leyes 1 = very stronly disagree 2 = strongly disagree; 3 disagree, 4 = nel 1 - very stronly disagree, 2 = strongly disagree; 3 = disagree: 4 = nel 1 = very stronly disagree: 2 strongly disagree: 3 disagree, 4 =ne 1 = very stronly disagree: 2 strongly disagree: 3 disagree; 4 = net 1 = very stronly disagree, 2 strongly disagree; 3 disagree:4 une 1 = very stronly disagree, 2 strongly disagree, 3 - disagree, 4 neit 1 Every undesirable: 2 undesirable, 3somewhat undesirable, 4 1 = very undesirable; 2 - undesirable, 3 = somewhat undesirable; 4. 1 very undesirable 2 undesirable, 3 somewhat undesirable; 4 1 very undesirable; 2 undesirable, 3somewhat undesirable: 4 1 very undesirable, 2 undesirable, 3somewhat undesirable 4 1 - does not describe me at a describes me perfectly 1 .does not describe me at all describes me perfectly 1 - does not describe me at all describes me perfectly 1 - does not describe me at all-7. describes me perfectly 1 - does not describe mest all-7.describes me perfectly 1.does not describe me atat describes me perfectly 1 comedy, 2 drama; 3-moveles/miniseries; 4. documentary, 5. 1 classic pop & rock; 2 country, 3 - easy listening 4. jan & blue 1.business & money 2. music & entertainment family & paren 1 editorial, 2 business, 3 local news; 4 national news5 sport less than 1 hour: 1 about 1 hour, 2 about 2 hours: 3 about o less than 1 hour about 1 hour, 2 about 2 hours: 3 about o less than 1 hour, 1 - about 1 hour; 2 - about 2 hours, about o less than 1 hour 1 about 1 hour: 2 - about 2 hour; about 0-less than 1 hour about 1 hour;2bout 2 hours; 3 - about Part 1: Descriptive Analysis For each of the following questions, it is your task to determine the type of scale for each variable, conduct the proper descriptive analysis with Excel, and interpret it: 1. What is the demographic composition of the sample? 2. How do respondents feel about concern for global warming? 3. What percent of Americans own an economy or standard automobile or luxury auto or truck? . X V fx income 3 K A B cartype plan warming gasem 5 5 5 4 1 3 4 4 3 3 4 mm 00 00 00 00 00 00 00 00 OOOOO NN 0 un 88 4 0 4 1 3 5 5 5 5 5 7 5 6 4 4 6 5 4 3 NWN 00 00 00 00 00 H D E F marital familysize age edcation income Thometype 0 3 1 1 55 125 1 3 8 45 0 88 3 1 1 3 35 8 125 1 0 1 2 45 6 63 1 1 1 35 8 88 1 0 1 2 45 125 3 1 1 3 35 3 8 0 1 4 45 8 125 2 1 1 3 35 8 125 1 0 1 3 55 10 175 2 1 1 45 8 125 1 1 1 3 35 8 125 2 0 D 1 45 6 63 3 0 1 2 45 6 63 4 1 0 1 35 8 88 1 1 1 4 35 8 125 1 0 0 1 45 8 88 1 1 1 2 35 6 63 2 1 1 2 88 3 1 1 3 35 8 125 2 0 1 2 55 8 125 1 1 3 45 6 63 1 1 2 65 6 88 3 1 2 65 4 63 1 0 1 55 4 63 3 1 2 35 6 88 2 D 1 45 4 63 3 0 1 2 65 6 88 3 1 1 3 35 8 88 1 0 1 2 55 6 88 4 1 1 4. 35 8 88 2 1 1 3 35 8 2 1 1 3 35 8 88 0 1 2 65 6 88 3 0 1 2 65 8 25 2 0 1 2 45 6 88 2 0 0 2 25 4 25 2 26 Auto Concepts Codebook + townsize gender 1250 300 55 300 300 7 750 8 300 9 55 10 55 11 300 12 750 13 300 14 750 15 750 16 750 17 55 18 750 19 750 20 750 21 750 22 1250 23 750 24 55 25 55 26 55 27 300 28 750 29 55 30 55 31 55 32 300 33 300 34 750 35 5 36 5 37 750 38 1250 20 ann 0 0 1 0 0 0 0 1 0 0 1 1 1 2 4 2 3 4 4 on 6 4 NN 5 35 6 2 1 6 3 4 1 4 WN NN + NN OOOOO NNN 1 4 NNN O 000 3 1 6 1 4 6 5 5 5 5 NMM 1 3 2 3 3 2 2. 3 2 4 How OOOOOOOOO 1 1 5 5 5 4 4 M NNNN NNNWN N 5 4 5 4 1 1 1 1 1 Ready Values 5 Under 10:55 - 10K to 100K: 300 - 100k to 500k; 750 - 500 Os male; 1 = female 0 - unmarried; 1 = married (Includes cohabitation) 6 1 Variable Name Label 2 townsize Size of home town or city gender Gender 4 marital Marital status 5 familysize Number of people in household Age 7 edcation Level of education B income Household income level 9 hometype Dwelling type 10 cartype Auto or truck type owned 11 plan Plan to purchase or lease a vehicle in the coming year 12 warming I am worried about global warming, 13 gasemit Gasoline emissions contribute to global warming 14 threat Global warming is a real threat. 15 conserve I drive conservatively to use less fuel 16 checktraffic I check traffic reports to avoid idling in traffic. 17 fue efficient I drive an automobile that is fuel efficient 18 supercycle seat Desirability: Super Cycle-1 Seat All-Electric Motorcycle 19 runaboutsport2seat Desirability: Runabout Sport - 2 Seat Al-Electric 20 runaboutstowage seat Desirability: Runabout with Stowage - 2 Seat Electric & Gasoline Hybrid 21 economyhybrid seat Desirability: Economy Hybrid - 4 Seat Electric & Gasoline Hybrid 22 economy asset Desirability: Economy Gasoline 4 Seat Economy Gasoline 23 lifestyle Life Style: Novelist 24 lifestylez Life Style: Innovator 25 lifestyle Life Style: Trendsetter 26 lifestyle Life Style: Forerunner 27 lifestyles Life Style: Mainstreamer 28 lifestyle Life Style: Classic 29 television Favorite television show type 30 radio Favorite radio genre 31 magazines Favorite magazine type 32 newspaper Favorite local newspaper section 33 blogs Use of online blogs 34 YouTube Use of content communities 35 Facebook Use of social network sites 36 Games Use of online games 17 Virtworld Use of virtual worlds 25 = 20-29;35 - 30 to 39:45 = 40 to 49;55 - 50 to 59,65 +60 0 = less than high school; 4 = high school graduate; 6 = some colle 25 - under $50k: 63 - $Sok to $75k; 88 - $76k to $100k, 1255 1 - single family, 2 multiple family, 3 - condominium/townhouse 1-none; 2 economy, 3 - standard; 4 - luxury 0no;leyes 1 = very stronly disagree 2 = strongly disagree; 3 disagree, 4 = nel 1 - very stronly disagree, 2 = strongly disagree; 3 = disagree: 4 = nel 1 = very stronly disagree: 2 strongly disagree: 3 disagree, 4 =ne 1 = very stronly disagree: 2 strongly disagree: 3 disagree; 4 = net 1 = very stronly disagree, 2 strongly disagree; 3 disagree:4 une 1 = very stronly disagree, 2 strongly disagree, 3 - disagree, 4 neit 1 Every undesirable: 2 undesirable, 3somewhat undesirable, 4 1 = very undesirable; 2 - undesirable, 3 = somewhat undesirable; 4. 1 very undesirable 2 undesirable, 3 somewhat undesirable; 4 1 very undesirable; 2 undesirable, 3somewhat undesirable: 4 1 very undesirable, 2 undesirable, 3somewhat undesirable 4 1 - does not describe me at a describes me perfectly 1 .does not describe me at all describes me perfectly 1 - does not describe me at all describes me perfectly 1 - does not describe me at all-7. describes me perfectly 1 - does not describe mest all-7.describes me perfectly 1.does not describe me atat describes me perfectly 1 comedy, 2 drama; 3-moveles/miniseries; 4. documentary, 5. 1 classic pop & rock; 2 country, 3 - easy listening 4. jan & blue 1.business & money 2. music & entertainment family & paren 1 editorial, 2 business, 3 local news; 4 national news5 sport less than 1 hour: 1 about 1 hour, 2 about 2 hours: 3 about o less than 1 hour about 1 hour, 2 about 2 hours: 3 about o less than 1 hour, 1 - about 1 hour; 2 - about 2 hours, about o less than 1 hour 1 about 1 hour: 2 - about 2 hour; about 0-less than 1 hour about 1 hour;2bout 2 hours; 3 - about