View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
les8 les8 is offline
external usenet poster
 
Posts: 10
Default 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