Question

In: Math

The cost of adding a new communication node at a location not currently included in the...

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?

Solutions

Expert Solution

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


Related Solutions

Birnham Motors is considering adding a new location to their existing car lots. The new facility...
Birnham Motors is considering adding a new location to their existing car lots. The new facility will cost $12.7 million to construct. Management uses a discount rate of 10.9%. They anticipate the following cash flows for next seven years: Year Cash Flow 1 2.2m 2 2.5m 3 2.9m 4 3.1m 5 3.4m 6 3.6m 7 3.9m The proposed project's net present value is closest to:
Advance Engineering is considering opening a new location with an initial cost of $398,0000. This location...
Advance Engineering is considering opening a new location with an initial cost of $398,0000. This location is expected to generate cash flows of $117,000, $121,000, $126,000, $133,000, and $142,000 in Years 1 to 5. What is the payback period?
Extend the custom unorderedLinkedList class by adding the following operation: Find and delete the node with...
Extend the custom unorderedLinkedList class by adding the following operation: Find and delete the node with the smallest info in the list. Delete only the first occurrence and traverse the list only once. The function's prototype is deleteSmallest() use this code #include <ctime> #include <iostream> #include <random> #include "unorderedLinkedList.h" using namespace std; int main() { default_random_engine e(1918); uniform_int_distribution<int> u(10, 99); int size = 12; unorderedLinkedList ul; while (ul.getnelts() < size) { int elt = u(e); ul.append(elt); ul.show(); cout << endl;...
Statictics and Proability In a data communication system, several messages that arrive at a node are...
Statictics and Proability In a data communication system, several messages that arrive at a node are bundled into a packet before they are transmitted over the network. Assume that the messages arrive at the node according to a Poisson process with λ = 30 messages per minute. Five messages are used to form a packet. a. What is the mean time until a packet is formed, that is, until five messages have arrived at the node? b. What is the...
Jamaica Corp. is adding a new assembly line at a cost of $8.5 million. The firm...
Jamaica Corp. is adding a new assembly line at a cost of $8.5 million. The firm expects the project to generate cash flows of $2 million, $3 million, $4 million, and $5 million over the next four years. Its cost of capital is 16 percent. What is the internal rate of return (IRR) that Jamaica can earn on this project and should the project be accepted? (Round to the nearest percent)? A. 18 percent, yes because IRR > r B....
Sun National Bank is considering adding a new branch bank. They know that it will cost...
Sun National Bank is considering adding a new branch bank. They know that it will cost $1.25 million to build the branch and they believe that it will generate $220,000 per year for the next 30 years. Sun National Bank requires a return of 10% on all new projects it undertakes. What is this project’s net present value? (10 points) (Show all calculations for full credit. Simply entering a single value will earn no credit.)
How does therapeutic communication differ from normal communication? Explain the four basic elements included in the...
How does therapeutic communication differ from normal communication? Explain the four basic elements included in the communication style.
Tommy bought a new computer from a company in California for $1,489, which included the cost...
Tommy bought a new computer from a company in California for $1,489, which included the cost of the computer plus shipping ($50) and handling ($20), but no sales tax was collected. Tommy received the package at his home outside of Liberal, Kansas, which is located in Seward County. Kansas has a sales tax rate of 6.500%, to which Seward County residents add 1.250%. What is the amount of compensating use tax that should be reported on Tommy's Kansas tax return?...
Can you fix please? this is adding the given location of doubly linked list in java...
Can you fix please? this is adding the given location of doubly linked list in java but if I make reverse is not adding the new node that I added but is printing forward correctly. just fix to me that part public void addAtLocation(E newNode, int location) {        Node node = new Node(newNode);               node.data = newNode;               Node previous = head;                      int counter = 1;...
Yilan Company is considering adding a new product. The cost accountant has provided the following data....
Yilan Company is considering adding a new product. The cost accountant has provided the following data. Expected variable cost of manufacturing$49 per unit   Expected annual fixed manufacturing costs$68,000 The administrative vice president has provided the following estimates. expected sales commission $3 per unit Expected annual fixedadministrative costs 52000 a)If the sales price is set at $67, how many units must Yilan sell to break even? b)Yilan estimates that sales will probably be 10,000 units. What sales price per unit will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT