In: Math
The cost of adding a new communication node at a location not currently included in the network is of concern to a major manufacturing company. To try to predict the price of new communication nodes, data were obtain on a random sample of existing nodes.
We have information on the following variables:
?: Installation cost of the node, in U.S. dollars (COST)
?1: Number of ports available for access (NUMPORTS)
?2: Bandwidth (BANDWIDTH)
?3: Port speed (PORTSPEED)
Use MINITAB to answer the following questions.
COST NUMPORTS BANDWIDTH PORTSPEED
52388 68 58 653
51761 52 179 499
50221 44 123 422
36095 32 38 307
27500 16 29 154
57088 56 141 538
54475 56 141 538
33969 28 48 269
31309 24 29 230
23444 24 10 230
24269 12 56 115
53479 52 131 499
33543 20 38 192
33056 24 29 230
Perform a global F-test by completing the following steps:
a. The null hypothesis is ?0: ?1 = ?2 = ?3 = 0, what is the alternative hypothesis?
b. What is the p-value for this test?
c. Is there evidence that at least one explanatory variable (number of ports, bandwidth, or port speed) is useful in explaining the variation in the installation cost for communication nodes? (Circle one) i. Yes ii. No
d. What is the value of the MSE for the full model?
Stat -> regression -> regression -> fit regression model
a)
Ha: not all betas are 0
b)
p-value = 0
c)
yes
since p-value < alpha
we reject the null hypothesis
there is sufficient evidence that at least one explanatory variable
(number of ports, bandwidth, or port speed) is useful in explaining
the variation in the installation cost for communication nodes
d)
MSE = 9510805
Please rate