LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Correlation analysis todd012976459210 Excel Worksheet Functions 6 October 16th 08 10:23 PM
regression analysis usedtostata Excel Discussion (Misc queries) 6 October 2nd 08 09:50 PM
Using Regression Analysis? ccpalm2 New Users to Excel 1 February 21st 07 10:03 AM
In Regression Analysis, How do you get a Correlation Matrix to be. tjp32 Excel Discussion (Misc queries) 1 April 4th 05 08:59 PM


All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"