Please use excel, I need to know how to solve it by excel sheet. thank u.

2. A survey of 500 randomly selected automobile owners were questioned on the main reason they had purchased their current automobile. The results are given below. Styling Engineering Fuel Economy | Total Male 70 130 150 Female 30 20 100 Total (a) What is the probability that a randomly automobile owner is a male? Page 1 of 8 BUSI 275 Business Statistics (b) What is the probability that the automobile owner is a male whose main reason for purchasing the automobile was engineering? (c) What percentage of automobile owners chose engineering as their main reason for purchasing an automobile? (d) What percentage of male automobile owners chose engineering as their primary reason for purchasing automobile? (e) What percentage of females chose engineering as their primary reason for purchasing automobile? (f) Among the 500 automobile owners, who is more likely to choose engineering as their main reason for purchasing an automobile-men or women? (g) Among those automobile owners for whom engineering was the main reason for purchasing an automobile, what is the probability that they are male? (h) Does the data provide sufficient evidence of differences between men and women as to their main reason for purchasing an automobile? Test at a 5% level of significance. (i) If you concluded that the distributions are not different between men and women, analyze the differences using the standardized residuals of your calculations