stat analysis homework and excel lab

DS 123 – Tutorial Assignment # 4

Chaffe-Stengel

Hypothesis tests: t-tests of two population means, equal & unequal variances

1. Read Problem 10.22 on page 409-10. Assuming the auto loan rates are independently sampled and normally distributed, conduct 5-part formal hypothesis tests side-by-side, on the left in the t-statistic and on the right in the p-value, to test whether the average shopping expenses differ. Use  = 0.01.

2. A local bank ran a spot advertising campaign on their 30-year fixed-rate home mortgage. Branch A is located in a large shopping mall anchored by a department store and produced a sample of 14 randomly selected applications for home mortgage loans shown below during the advertising campaign. Branch B is located in a shopping mall anchored by a national grocery chain and produced a sample of 16 randomly selected applications for home mortgage loans shown below during the advertising campaign. Use the unequal variances t-test to test whether there was any difference in the average amounts of home mortgages applied for at the two branches. Use  = 0.05.