Home

Statistical models in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-97893%22%20slang%3D%22en-US%22%3EStatistical%20models%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-97893%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3BI%20am%20trying%20to%20see%20how%20I%20can%20build%20a%20simple%20statistical%20model%20in%20Excel.%20Let's%20say%20I%20have%2010%20salespeople.%20For%20each%20of%20them%2C%20they%20have%20sold%20X%20amount%20of%20the%20year.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20see%20the%20relationship%20between%20data%20I've%20collected%20about%20their%20differing%20sales%20experience%2C%20industry%20experience%2C%20calls%2C%20demos%20and%20see%20whether%20there%20is%20a%20correlation%20in%20positively%20affecting%20their%20sales%20performance%20for%20that%20year.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20haven't%20used%20statistical%20modeling%20in%20Excel%20very%20much.%20Does%20anyone%20have%20an%20indication%20how%20I%20can%20set%20it%20up%20in%20Excel%3F%20Any%20tips%20would%20be%20huge.%20Many%20thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-97893%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecorrelation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Emodelling%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Emodels%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Estatistics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Evariables%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-97908%22%20slang%3D%22en-US%22%3ERe%3A%20Statistical%20models%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-97908%22%20slang%3D%22en-US%22%3E%3CP%3EActivate%20the%20Analysis%20Toolpak%20add-in%20(alt%2Bt%2C%20i)%20and%20check%20out%20the%20options.%20It%20gives%20you%20a%20new%20group%20on%20your%20Data%20tab%20called%20%22Analysis%22%20with%20a%20button%20called%20%22Data%20Analysis%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
David Liu
Occasional Visitor

Hi Guys,

 

   I am trying to see how I can build a simple statistical model in Excel. Let's say I have 10 salespeople. For each of them, they have sold X amount of the year.

 

I want to see the relationship between data I've collected about their differing sales experience, industry experience, calls, demos and see whether there is a correlation in positively affecting their sales performance for that year.

 

I haven't used statistical modeling in Excel very much. Does anyone have an indication how I can set it up in Excel? Any tips would be huge. Many thanks in advance.

1 Reply

Activate the Analysis Toolpak add-in (alt+t, i) and check out the options. It gives you a new group on your Data tab called "Analysis" with a button called "Data Analysis".

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