I just need #2 (the highlghted #2) this is all the information i have. . Project
ID: 3259248 • Letter: I
Question
I just need #2 (the highlghted #2) this is all the information i have.
. Project 3-Answer Sheet Search in Document Home Insert Design Layout References Mailings Review View + Share A Paste Styles Pane No Spacing Hending 1 Heading 2 Emphasis SAMS- Project 3 BOX all your numerical answersTYPED!!! 1 Test with a significance of 0.05 whether there is evidence that the population mean upload speed is less than 0.97, Be sure to show all 8 steps and report p-value as well. (40 points) Establish a null and alternative hypothesis HO: 1. HA: Is this a one-tailed or two-tailed test? How do you know? 2. Determine the appropriate statistical test (explain why you are using the test that you chose) 3. Set the value of alpha, find critical values and explain the Type l error rate critical values Explain what the Type l I error means in terms of the problem/data. 4. Establish the decision rule (clearly show the rejection region shaded and label the critical values.. .this part can be hand drawn in the graph below) Page 1 of 3 395 Words English (USExplanation / Answer
Answer to question# 2)
Since there is no data provided , I can guide you through the steps and formulae to be used for this question
There are 15 subscribers in each of the groups
First of in excel find the variances of both the groups:
formula to be used is : =VARS(range)
Like this we get the value of 1 square & 2 square
now the variance that s larger comes in the numerator
.
Noe suppose 1 square > 2 square
then the value of F statistic = 1 square / 2 square
.
df numberator = 15-1 = 14
df denominator = 15-1 = 15
.
Alpha = 0.05
.
Formula of F llower critical value is : =f.inv(0.025,14,14)
We get F lower critical value = 0.33573
.
Formula of F upper critical value is: =f.inv.rt(0.025,14,14)
We get F upper critical value = 2.978588
.
The formula for P value is : =f.dist.rt(F statistic value , 14,14)
.
Like this we can answer all the parts of this question.
If there is any confusion at any point please share, or else please share for complete calculations