Question: Can someone perform a Multiple Linear Regression Analysis in excel using Ford's total supply chain costs from 2 0 1 8 to 2 0 2
Can someone perform a Multiple Linear Regression Analysis in excel using Ford's total supply chain costs from to The analysis will help me determine which variables are most significant in driving supply chain costs Data:
Dependent Variable Y: Total Supply Chain Costs USD
Independent Variables X:
Shipping Costs USDUnit
Raw Material Prices USDton
Production Volume Units
Control Variables
Exchange Rate USDCNY
Fuel Prices USDLiter
build the regression model and generate the following outputs:
Coefficients for each variable
pvalues for statistical significance
Rsquared value to evaluate model fit
A summary of the regression equation
Confidence intervals for each coefficient
Forecasts of future supply chain costs based on potential changes in these variables for and beyond
Additionally, if any variables are constant or do not have a significant effect on the outcome egexchange rateplease feel free to change it or adjust it same thing with any issues with multicollinearity or other assumptions. Noting that i already did all the steps but the regression model is always wrong.theres a problem with the data that I dont know about i hope u can fix it for me
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
