Question 1. The "Question 1.xlsx" file comprises data on the family size and income information of 343 households that have purchased a sedan-type car. Using the data set given on the "Data" sheet of the MS Excel file "Question 1.xlsx", answer the following questions:
a) Is either family size or income a more decisive factor in purchasing a sedan-type car?
b) Construct a table that demonstrates the percentage of households with respect to the income parameter.
Question 2. Suppose you are working on a data set that includes demographic information of subscribers to the magazine USA Today Sports Weekly. You aim to develop a list of recommendations about how to advertise, where to promote the magazine, and to whom to target. The "Question 2.xlsx" file comprises the data set on demographic information of 1,024 subscribers to USA Today Sports Weekly. Using the data set given on the "Data" sheet of the MS Excel file "Question 2.xlsx", answer the following questions.
a) Conduct an analysis to develop an understanding of the age distribution of subscribers to the magazine USA Today Sports Weekly.
b) According to the analysis you have performed in part a), which age groups do you recommend targeting in the upcoming marketing campaign? Please state your reasoning.
c) Conduct an analysis to develop an understanding of the gender distribution of subscribers to USA Today Sports Weekly.
d) Based on the analysis you have performed in part c), would you advertise the magazine on a television series that focuses on fashion design? Please state your reasoning.
Question 1 Excel:
Customer ID | Sedan? | Family Size | Income
1 | No | Small | High
2 | Yes | Large | High
3 | Yes | Large | High
4 | Yes | Large | High
5 | Yes | Large | High
6 | No | Small | High
7 | Yes | Large | High
8 | Yes | Large | High
9 | Yes | Large | Low
10 | Yes | Large | High
11 | Yes | Large | Low
12 | No | Small | Low
13 | No | Small | Low
14 | No | Small | High
15 | Yes | Large | High
16 | Yes | Large | High
17 | No | Small | High
18 | Yes | Large | High
19 | No | Small | High
20 | No | Large | Low
21 | Yes | Large | High
22 | No | Small | High
23 | No | Small | Low
24 | No | Small | Low
25 | Yes | Large | High
26 | No | Large | High
27 | No | Small | High
28 | No | Large | Low
Question 2 Excel:
Customer ID | Age | Gender | Income | Location
1 | 72 | m | 72 | rural
2 | 29 | m | 68 | suburban
3 | 33 | m | 57 | suburban
4 | 25 | m | 62 | suburban
5 | 38 | m | 164 | urban
6 | 33 | m | 44 | urban
7 | 18 | f | 62 | rural
8 | 17 | m | 68 | urban
9 | 32 | f | 53 | urban
10 | 24 | f | 92 | urban
11 | 26 | f | 54 | suburban
12 | 40 | m | 88 | urban
13 | 26 | f | 46 | rural
14 | 21 | m | 83 | suburban
15 | 29 | m | 144 | rural
16 | 51 | f | 30 | suburban
17 | 17 | m | 47 | urban
18 | 29 | m | 61 | urban
19 | 92 | m | 123 | urban
20 | 20 | m | 76 | suburban
21 | 20 | f | 57 | rural
22 | 65 | m | 104 | urban
23 | 26 | m | 46 | urban
24 | 74 | m | 113 | urban
25 | 37 | f | 109 | rural
26 | 21 | m | 131 | suburban
27 | 13 | f | 109 | urban
28 | 17 | m | 59 | suburban
29 | 43 | m | 112 | suburban
30 | 27 | m | 114 | urban