ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Correlation between 2 or more variables (https://www.excelbanter.com/excel-discussion-misc-queries/57299-correlation-between-2-more-variables.html)

[email protected]

Correlation between 2 or more variables
 

I have the following information for total costs, total revenue,# of orders,
#of units as well as the information as what constitutes the total costs.
I would like to know how would I go determining if I changed total costs by
varying one the the costs that affects it for example training costs, how
that would affect # of orders. I tried regression analysis using Excel but
the output did not make any sense

PeterAtherton

Correlation between 2 or more variables
 


" wrote:


I have the following information for total costs, total revenue,# of orders,
#of units as well as the information as what constitutes the total costs.
I would like to know how would I go determining if I changed total costs by
varying one the the costs that affects it for example training costs, how
that would affect # of orders. I tried regression analysis using Excel but
the output did not make any sense


It might help if you included some figures

Peter

Jerry W. Lewis

Correlation between 2 or more variables
 
And an elaboration on "the output did not make any sense."

Jerry

PeterAtherton wrote:


" wrote:


I have the following information for total costs, total revenue,# of orders,
#of units as well as the information as what constitutes the total costs.
I would like to know how would I go determining if I changed total costs by
varying one the the costs that affects it for example training costs, how
that would affect # of orders. I tried regression analysis using Excel but
the output did not make any sense


It might help if you included some figures

Peter




All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com