Can anyone help mw with this, it has to be entered in excel with a conclusion and a decision.

I will attach an example of how I been doing these, but these 2 I am unsure of. Not sure if you can show me on excel. with functions TYIA

94. A recent survey in theN.Y. Times Almanacindicated that 48.8% of families own stock. A broker wanted to determine if this survey could be valid. He surveyed a random sample of 250 families and found that 142 owned some type of stock. At the 0.05 significance level, can the survey be considered to be accurate?

94) Ho:

Ha:

99. A survey in theN.Y. Times Almanacfinds the mean commute time (one way) is 25.4 minutes for the 15 largest US cities. The Austin, TX chamber of commerce feels that Austin's commute time is less and wants to publicize this fact. The mean for 25 randomly selected commuters is 22.1 minutes with a standard deviation of 5.3 minutes. At the = 0.10 level, is the Austin, TX commute significantly less than the mean commute time for the 15 largest US cities?

99) Ho:

Ha: