Please solve question 1 using EXCEL. Please show all the detailed steps.

Topic: Hypothesis Testing: Single Sample

Q1. In an early study, researchers at a private University found that 33% of the freshmen had received at least one A in their first semester. University administrators have received report that grade inflation may have caused this percentage to increase recently. A random sample of 500 freshmen found that 180 had at least one A in their first semester. Calculate the appropriate test statistic and test the hypotheses related to the concern and test at 5% and 1%.

Feel free to solve question 2 without excel.

Topic: Sampling Distributions of Sample Means and Proportions

Q2. Quarterly internal audits are used to calculate the proportion of delinquent accounts. The long run experience shows that about 13 % of the accounts were delinquent. For this quarter, 250 customer accounts are randomly picked. The probability of fewer than 40 accounts in the sample classified as delinquent is:

a. 0.0793

b. 0.4207

c. 0.9015

d. 0.9207

e. 0.4015