Activity 3 – advanced statistical concepts and business analytics

Question:

Although natural gas is currently inexpensive and nuclear power currently (and perhaps deservedly) does not have a good reputation, it is possible that more nuclear power plants will be constructed in the future. Table 4 presents data concerning the construction costs of light water reactor (LWR) nuclear power plants. The dependent variable, C, construction cost, is expressed in millions of dollars, adjusted to a 1976 base. Preliminary analysis of the data and economic theory indicate that variation in cost increases as cost increases. This suggests transforming cost by taking its natural logarithm.

S Power plant capacity in MWe

N Cumulative number of power plants built by the contractor 

1. Build a multiple regression model to predict ln(C) by taking S and N or their natural logarithms as the independent variables. Make sure to check for multicollinearity.

2. Use residual analysis and R2 to check your model.

3. State which variables are important in predicting the cost of constructing an LWR plant, and 

4. State a prediction equation that can be used to predict ln(C).

Table 4

Data Concerning Construction of Light Water Reactors

(Please find table 4 in the attachment)

Note:

1. Need to have at least 1 peer-reviewed article as the reference and textbook as the reference

2. Need in-text citation

3. Please find the attachments as the power points of the course for reference.

4. Textbook Information:

Bowerman, B., Drougas, A. M., Duckworth, A. G., Hummel, R. M. Moniger, K. B., & Schur, P. J.  (2019). Business statistics and analytics in practice (9th ed.). McGraw-Hill

ISBN 9781260187496

5. Please find the Course Learning Outcome list of this course in the attachment

6. Please provide your work in detail and include in-text citations.

7. Please find Table 4 in the attachment

8. Please find the attached 2 excel files as the sample of the activity

9. Need to use data analysis method of  “Regression” in the excel

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.