SHOW THE ANSWER ON EXCEL WITH CALCULATIONS PLEASE

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 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 in 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