Null Hypothesis  Alternative Hypothesis
Identify the null hypothesis and alternative hypothesis from a given claim, and determine how to express both in symbolic form.
The formulas and data are attached. What is needed is to do is explain what is going on in the Excel spreadsheet; basically, make a translation of the math into english.

Null Hypothesis
The housing price decline in Sacramento was equal to that of the nation between the years 2007 and 2008.
H0 = National Means for Housing Price Decline

Alternative Hypothesis
The housing price decline in Sacramento was greater to that of the nation between the years 2007 and 2008.
H1 > National Means for Housing Price Decline

Project fulfills the one sample / onetailed Z Test requirement
This is the problem:
Identify the null hypothesis and alternative hypothesis from a given claim, and determine how to express both in symbolic form.
https://brainmass.com/statistics/hypothesistesting/nullhypothesisalternativehypothesis320378
Solution Preview
Hi,
This is a situation that should be tested using a z test, since you have more than 30 scores in your sample and you know your population standard deviation. That means you'd have used the following formula:
z=xbarmu/(sigma/sqrt(n)), where xbar is your sample (City A) mean, mu is your population (national) mean, sigma is
your population standard deviation, and n is your sample size.
You didn't have your population standard deviation calculated in the Excel file, so I've calculated it and highlighted ...
Solution Summary
The null and alternative hypothesis are examined.