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".