Home

Find coefficent of determination for many X variables and many Y variables at once

%3CLINGO-SUB%20id%3D%22lingo-sub-901017%22%20slang%3D%22en-US%22%3EFind%20coefficent%20of%20determination%20for%20many%20X%20variables%20and%20many%20Y%20variables%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901017%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20large%20data%20set%20of%20X%20and%20Y%20variables.%20I%20am%20hoping%20to%20be%20able%20to%20forecast%20Y%20variables%20by%20changing%20the%20forecast%20of%20X.%20For%20example%20if%20X%20variable%20drops%2010%25%2C%20the%20impact%20it%20will%20have%20on%20a%20range%20of%20Y%20Variables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20example%20with%20some%20X%20variables%20(interest%20rates%2C%20petrol%20price%2C%20etc).%20I%20will%20to%20create%20a%20template%20or%20model%20which%20will%20show%20the%20impact%20on%20each%20Y%20variable%20if%20i%20can%20change%20x.%20I%20assume%20i%20need%20to%20find%20a%20coefficent%20of%20determination%20for%20each%20variable.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERefering%20to%20the%20attached%20spreadsheet%20an%20example%20i%20am%20trying%20to%20find%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBHP%20%3D%20Intercept%20%2Bb1*(Petrol%20Price)%20%2B%20b2*(%20Interest%20Rates)%20%2Bb3*(%20Iron%20Ore%20Price)%20%2B%20b4*(%20Interest%20Rates)%20%2B%20b5*(%20USD%20to%20AUD)%2C%20and%20Model%20-%20means%20known%20b1%2C%20b2%2C%20...b5%20.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20an%20efficent%20way%20to%20see%20this%20up%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20kindly%20for%20any%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-901017%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
calof1
Contributor

Hi,

 

i have large data set of X and Y variables. I am hoping to be able to forecast Y variables by changing the forecast of X. For example if X variable drops 10%, the impact it will have on a range of Y Variables.

 

I have attached an example with some X variables (interest rates, petrol price, etc). I will to create a template or model which will show the impact on each Y variable if i can change x. I assume i need to find a coefficent of determination for each variable.

 

Refering to the attached spreadsheet an example i am trying to find:

 

BHP = Intercept +b1*(Petrol Price) + b2*( Interest Rates) +b3*( Iron Ore Price) + b4*( Interest Rates) + b5*( USD to AUD), and Model - means known b1, b2, ...b5 .

 

Does anyone know an efficent way to see this up?

 

Thank you kindly for any assistance.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies