Aim: To plot graphs and construct regression model. Consider the weekly production and energy consumption for a factory. Week Production (tonnes) 1 150 Energy (kWh) 140726 103223 3 60 90764 4 50 87567 170 146600 6 180 154773 7 120 121575 8 40 81436 9 110 115586 10 90 105909 11 40 83916 12 50 86272 140 125892 14 155 138966 15 165 139922 16 190 152274 17 40 77788 18 55 82711 150 124317 20 80 94677 21 63 84628 22 110 108041 70 136388 190 141428 26 160 141215 27 120 118319 28 190 29 80 152506 99267 30 90 94468 31 180 140188 70 91262 33 50 78248 89115 Specific energy (kWh/tonne) 34 155 128005 35 167 36 120 131003 109192 (i) Make a graph using excel where production and electricity consumption are plotted on one graph. Have electricity consumption on primary vertical axis and production on secondary vertical axis. Horizontal will have time (in weeks). Comment on the trend (ii) Calculate the specific energy in every week. (iii) Determine the average weekly specific energy. (iv) Determine the total production and total energy in 36 weeks. (v) Plot a scatter plot graph with y-axis having Energy consumption and x-axis having production. (vi) Add a linear trend line to the plotted graph in part (v) and put equation and R-squared value on the graph. (vii) Write a linear equation to predict electricity consumption. Give quantity and its units of all parameters in the equation. (viii) Use data analysis tool pack on MS Excel and carry out a simple linear re- gression. Present the results that you have obtained and explain what the values mean in the table. (ix) Compare the equation that you have obtained in parts (vii) and (viii) End of document

Aim: To plot graphs and construct regression model. Consider the weekly production and energy consumption for a factory. Week Production (tonnes) 1 150 Energy (kWh) 140726 103223 3 60 90764 4 50 87567 170 146600 6 180 154773 7 120 121575 8 40 81436 9 110 115586 10 90 105909 11 40 83916 12 50 86272 140 125892 14 155 138966 15 165 139922 16 190 152274 17 40 77788 18 55 82711 150 124317 20 80 94677 21 63 84628 22 110 108041 70 136388 190 141428 26 160 141215 27 120 118319 28 190 29 80 152506 99267 30 90 94468 31 180 140188 70 91262 33 50 78248 89115 Specific energy (kWh/tonne) 34 155 128005 35 167 36 120 131003 109192 (i) Make a graph using excel where production and electricity consumption are plotted on one graph. Have electricity consumption on primary vertical axis and production on secondary vertical axis. Horizontal will have time (in weeks). Comment on the trend (ii) Calculate the specific energy in every week. (iii) Determine the average weekly specific energy. (iv) Determine the total production and total energy in 36 weeks. (v) Plot a scatter plot graph with y-axis having Energy consumption and x-axis having production. (vi) Add a linear trend line to the plotted graph in part (v) and put equation and R-squared value on the graph. (vii) Write a linear equation to predict electricity consumption. Give quantity and its units of all parameters in the equation. (viii) Use data analysis tool pack on MS Excel and carry out a simple linear re- gression. Present the results that you have obtained and explain what the values mean in the table. (ix) Compare the equation that you have obtained in parts (vii) and (viii) End of document

Similar questions

The difference between Linear Regression and Logistic Regression. Note: Please make in table and with your own word
HWK 7: Regression 1. For the questions below answer first by techniques that do NOT use the R linear model function (lm) and then compare to what is gotten from the Im() function. You may use R for the calculations not including Im but show how you do them. X = [-2, 1, 2, -1, 0] Y = [25, 18, 13, 23, 16] %D a) Find the slope and intercept of the line b) Find the residuals, the average of the absolute value of the residuals, and the standard deviation of the residuals using the appropriate number of degrees of freedom. c) Calculate the correlation coefficient d) Calculate the F-value and explain what it means
The output for linear regression analysis has multiple numbers. How can we interpret the output? Can you share some hints.
Task 4: Given the data set with two dimensions X and Y: Calculate every step and not using libraries X Y HE 1435 4232 Use a linear regression method to calculate the parameters a and ß where y = a + Bx. (Show every step and not using libraries)
Analysts at a start-up company are analyzing 35 months of sales data. They partition the data (the first 20 observations are assigned to the training set; the most recent 15 months are in the test set). The only independent variable is T (month number, ranging from 1 to 35). Five models (polynomials of order 1 - 5) are fit to the data. The first order is just the linear model; the 2nd order polynomial is the quadratic model; order 3 is the cubic model, etc. In each case the model is fit on the training data, and scored on both the training and test data sets. The results are below. Based on this output, which is the best predictive model? Metrics AE RMSE MAE SSE Metrics AE RMSE MAE SSE Model 2 Model 3 Model 5 Model 4 Model 1 1 <0.000001 0.955978 0.792802 18.277907 1 -1.034550 1.424155 1.208991 30.423248 Training Data Scoring Models (Polynomial of order 1-5) 4 2 <0.000001 0.928791 0.759583 17.253086 3 <0.000001 <0.000001 0.928295 0.855568 0.761951 0.652212 17.234646 14.639962 Test Data…
A Ridge Linear Regression adds the sum of the squared values of the coefficients to the loss function to penalize large coefficients. Group of answer choices True False
We've built a logistic regression model in RapidMiner, and would like to use it to make predictions for some new data points. Which operator do we need: Performance Apply Model Cross Validation O Nominal to Numerical.
For evaluation of regression models, typically, the higher the [ Select ] ["Adjusted R Squared", "Residual Standard Error"] the better, and the lower the [ Select ] ["Adjusted R Squared", "Residual Standard Error"] , the better.
You are given the true labels and the predicted probabilities from logistic regression model for N test examples. Approximately compute the AUC scores for ROC and PR curves.
Assume the following simple regression model, Y = β0 + β1X + ϵ ϵ ∼ N(0, σ^2 ) Now run the following R-code to generate values of σ^2 = sig2, β1 = beta1 and β0 = beta0. Simulate the parameters using the following codes: Code: # Simulation ## set.seed("12345") beta0 <- rnorm(1, mean = 0, sd = 1) ## The true beta0 beta1 <- runif(n = 1, min = 1, max = 3) ## The true beta1 sig2 <- rchisq(n = 1, df = 25) ## The true value of the error variance sigmaˆ2 ## Multiple simulation will require loops ## nsample <- 10 ## Sample size n.sim <- 100 ## The number of simulations sigX <- 0.2 ## The variances of X # # Simulate the predictor variable ## X <- rnorm(nsample, mean = 0, sd = sqrt(sigX)) Q1 Fix the sample size nsample = 10 . Here, the values of X are fixed. You just need to generate ϵ and Y . Execute 100 simulations (i.e., n.sim = 100). For each simulation, estimate the regression coefficients (β0, β1) and the error variance (σ 2 ). Calculate the mean of…
We estimate the following LRM for the relationship between COURSE_EVAL and AGE of the instructor: E(COURSE_EVAL | AGE) = 4.774 -0.2154 * log(AGE) where the AGE variable is transformed with the logarithmic function. Provide an interpretation of the coefficient estimate -0.2154.
Q.1 Explain the different regularization techniques used with Linear regression to handle multivariate data.