Question
In doing a 1- Tail test. I have this set as a hypothesis, My data is below, I am very confused on the value of
In doing a 1- Tail test. I have this set as a hypothesis, My data is below, I am very confused on the value of p and the T.DIST.RT function
H0:u=342,365
Ha:u 342,365
Hypothesis: [Define the population parameter. Write null and alternative hypotheses. Note: For means, define a hypothesis that is less than the population parameter. My significance level i believe is =0.05. Describe the population parameter for the variable you are analyzing.- I dont know
Data analysis:[Summarize your sample data using appropriate graphical displays and summary statistics.]
[Provide at least one histogram of your sample data.]
[In a table, provide summary statistics including sample size, mean, median, and standard deviation.]
[Determine the appropriate test statistic (t).]
calculation is (mean - target)/standard error. In this case, the mean is your regional mean, and the target is the national mean.]
[Calculate the probability (pvalue).]
[Note: This calculation is done with the T.DIST.RT function in Excel: =T.DIST.RT([test statistic], [degree of freedom]). The degree of freedom is calculated by subtracting 1 from your sample size.]
Interpretation:
[Relate the pvalue and significance level.]
[Make the correct decision (reject or fail to reject).]
[Provide a conclusion in the context of your hypothesis.]
Mean | 228994.1536 |
Median | 215050 |
Mode | 169950 |
Standard Deviation | 79432.17347 |
Count | 500 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started