Solution-Build a parsimonious linear regression model

Build a parsimonious linear regression model

Assignment Help Business Management

Reference no: EM133168903

The facility manager at a pharmaceutical company wants to build a regression model to forecast monthly electricity cost. Three main variables are thought to dictate electricity cost (in $): (1) average outdoor temperature (in F), (2) working days per month, and (3) tons of product produced. A portion of the past year's monthly data is provided in "Electricity Cost" datasheet.

Use the provided data to answer the following questions:

Build a parsimonious linear regression model to forecast the electricity cost given the available variables.
Interpret the meaning of the Intercept and the slop of the linear regression model.
Predict the electricity cost of the facility if the average outdoor temperature is 24 F, the working days per months is 24 days, and 79 tons of product are produced.
Calculate the correlation between the variables. Is there multicollinearity in the model, and what is its effect if it does exist? Comment on the forecasted value.
What are the limitations of the model?

Data:

Cost	Ave Temp	Work Days	Tons Produced
24100	26	24	80
23700	32	21	73
26800	46	24	90
27400	61	23	69
30200	66	24	75
31500	73	23	80
30100	81	24	82
29500	85	24	80
26800	76	23	78
27500	61	24	79
28900	51	23	75
26000	39	22	69

Reference no: EM133168903

Questions Cloud

Determine the contribution margin in dollars : The average sales price was $35. During the month, fixed costs were $7,210 and variable costs were 60% of sales. Determine the contribution margin in dollars

Find several ways to overcome the obstacle : What advice would you give Dana? There are several ways to overcome the obstacle he faces, so be sure to consider all of them.

How much of this expenditure can warren deduct : How much of this expenditure can Warren deduct in 2021 assuming that expenditure is a prepayment for four months of landscape maintenance beginning May 1, 2022

Multiculturalism and globalization : How a company should consider and adapt its operational and administrative processes to the reality of multiculturalism and understand the role of an administr

Build a parsimonious linear regression model : The facility manager at a pharmaceutical company wants to build a regression model to forecast monthly electricity cost. Three main variables are thought to dic

Determine the net hst payable or refund for the quarter : All of the operations of June Ltd. are located in Ontario where the relevant HST rate is 13 percent. Determine the net HST payable or refund for the quarter

Mobile application for health services : Which one you would use for the Mobile application for health services. Schedule an appointment, see the bold test results, refill a prescription

Business that can be integrated with technology : 1. What is your company/business name and what is your business main concept? Elaborate in paragraph

Discuss the limitations of the internal control principle : Discuss the limitations of the internal control principle and suggest a policy the company should have in place to ensure prevention or early detection of fraud

User Account

All Pages

Build a parsimonious linear regression model

Reference no: EM133168903

Reference no: EM133168903

Questions Cloud

Reviews

Write a Review

Business Management Questions & Answers

Inability to communicate has led misunderstandings

Complexities of the global-local dilemma

Develop a customer oriented market positioning statement

What is the need for the process capability index

Calculate the annual equivalent

State three facts about the musculoskeletal

E-activity-have they launched new product

Create-an interface for automobile mechanics

Will china maintain its strong economic growth in years

Link organizational technology

Negotiations between mexicans and americans

Summarize the major aspects of your personality

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT