stat analysis homework and excel lab

profilefarhm9
lab_4_template.xls

Sheet1

Your name JMP OUTPUT
DS 123 Lab #4
Due: 10/03/2016
Question 1. Problem 10.12, p. 390
t-Test: Two-Sample Assuming Equal Variances
Fixed Rate
8.29% Fixed Rate Variable Rate
7.75% Mean
7.50% Variance
7.99% Observations
7.75% Pooled Variance
7.99% Hypothesized Mean
9.40% df
8.00% t Stat
P(T<=t) one-tail
Variable Rate t Critical one-tail
7.59% P(T<=t) two-tail
6.75% t Critical two-tail
6.99%
6.50% t-Statistic p-value
7.00%
Hypotheses:
Rejection Region: a = 0.05 a = 0.05
df = ?? Rej H0 if p-value < 0.05
t-coeff = ??
Rej H0 if t > ??
or t < ??
Test Statistic: t = ?? p-value = ??
Conclusion:
Since the test statistic of t = ?? falls Since the test statistic of
{above/below/between} critical bound of p-value = ?? falls {above/below}
t =??, we {reject/do not reject} H0 alpha = 0.05, we {reject/do not reject}
with at least 95% confidence. H0 with at least 95% confidence.
Implication:
There {is/is not} enough evidence to There {is/is not} enough evidence to
conclude that the mean rates for the conclude that the mean rates
fixed and variable rate auto loans differ. for the fixed and variable rate
auto loans differ.
Question 2. Problem Given on Assignment
Branch A F-Test Two-Sample for Variances
$307,000 JMP OUTPUT
$316,000 Branch A Branch B
$307,000 Mean
$305,000 Variance
$294,000 Observations
$303,000 df
$297,000 F
$286,000 P(F<=f) one-tail
$265,000 F Critical one-tail
$320,000
$315,000 t-Test: Two-Sample Assuming Unequal Variances
$328,000
$285,000 Branch A Branch B
$293,000 Mean
Variance
Branch B Observations
$304,000 Hypothesized Mean
$289,000 df
$296,000 t Stat
$283,000 P(T<=t) one-tail
$281,000 t Critical one-tail
$301,000 P(T<=t) two-tail
$298,000 t Critical two-tail
$303,000
$301,000 t-Statistic p-value
$288,000
$298,000 Hypotheses:
$286,000
$284,000
$283,000 Rejection Region: a = 0.05 a = 0.05
$277,000 df = ?? Rej H0 if p-value < 0.05
$273,000 t-coeff = ??
Rej H0 if t > ??
or t < ??
Test Statistic: t = ?? p-value = ??
Conclusion:
Since the test statistic of t = ?? falls Since the test statistic of
{above/below/between} the critical bound p-value = ?? Falls {above/below}
of t =??, we {reject/do not reject} H0 a = 0.05, we {reject/do not reject}
with at least 95% confidence. H0 with at least 95% confidence.
Implication:
There {is/is not} enough evidence to There {is/is not} enough evidence to
conclude that the average mortgages conclude that the average mortgages
applied for differ at the two branches. applied for differ at the two branches.

Sheet2

Sheet3