Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Correlation or Regression Analysis
Hi, My manager wants an analysis of these variables (He said correlation but I think he meant regression, but am not sure). I have no idea on how to proceed. What he wants is a graph that has conversion on the y axis, with the conversion points being what is graphed. I don't know what goes on the x axis. He said that he wants to know what stores are lower (conversion wise) and what factors would cause conversion to increase. (Conversion is calculated as transactions divided by traffic). Any help would be very much appreciated. Thank you. store Sales Conversion ATV Traffic Transactions 2 9,837 24.31% $43.14 938 228 3 12,035 27.24% $40.39 1,094 298 5 9,371 22.90% $40.39 1,013 232 11 12,747 23.79% $40.59 1,320 314 12 7,336 21.84% $46.72 719 157 13 4,515 22.39% $33.44 603 135 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Correlation analysis | Excel Worksheet Functions | |||
regression analysis | Excel Discussion (Misc queries) | |||
Using Regression Analysis? | New Users to Excel | |||
In Regression Analysis, How do you get a Correlation Matrix to be. | Excel Discussion (Misc queries) |