please show how to get answer using excel

1. I wish to determine if a course offered by Dog Speaker Inc. improves dog behavior. I have a sample of dogs in baddog.xls. The number of incidents of bad behavior (couch setting, biting the cat, barking at UPS delivery, getting in the trash can, etc.) for each dog, for a one week period before the course and for a one week period after the course are recorded. Did the course make a difference? Alpha = .01, 3 points each

A. The appropriate procedure in excel for this problem is

A. the paired t-test

B. the F test for equality of variances to determine which t-test to use

C. the t-test assuming equal variances

D. the t-test assuming unequal variances

E. Chi-square template

To determine if there is a change,

B.Ho: ____________

Ha: ____________

C. Test Statistic is _______________ 3 decimal places

D. Critical value is_____________ 3 decimal places

E. Statistical decision is?

F. Which statement is the correct interpretation of the results?

A. The course improved dog behavior

B. The course made dog behavior worse

C. Dog behavior was exactly the same before and after the course

D. Cannot tell if the course changed dog behavior

2. I wish to determine if the appraised value and selling prices of houses (two measurements of the same house) are significantly different in a given market. A SRS is taken data in K:smoss\busa3131\exam\appraised. Each house is measured twice. First it is appraised then the actual selling price of the same house. Alpha = .05 4 points each

A.Ho: ____________

Ha: ____________

B. Test Statistic is _______________ 3 decimal places

C. P-value is_____________ 4 decimal places

D. Decision is: (Statistical)

E. Which statement would be correct

A. The selling and appraised prices are exactly the same

B. The selling price is lower than the appraised price

C. The appraised price is lower than the selling price

D. Cannot determine if the selling price and appraised price are different