How often do you use Tools:Data Analysis?

InTurn123

Board Regular
Joined
Jun 28, 2006
Messages
50
Hi,

Just wondering how often you use data analysis at your job. I used some of the things in a class last semester under data analysis like regression, t-test, Z-test, f-test, etc. I'm curious to know how often it's used if you even use it at all.

Thanks,

Jon the Intern.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
I worked as a Mechanical Design Engineer for about 5 years, and a Mechanical Test Engineer for the last 2... even though I manipulate test data occassionally, I can't say that I have ever had a need to install the Data Analysis toolpack at all. F-test, Z-test, T-test... I can't say that I even remember what they are for, since I haven't seen them since my college course work.
 
Once in a while. My company went through a "six sigma" phase a few years back and so the terms became en vogue for a brief time. In theory you would really need them to truly measure process improvement projects. But Six Sigma notwithstanding if you try to use the terms "confidence interval" or "fail to reject the null hypothesis" in a presentation to senior management their eyes will glaze over. If you can't distill your point down to a very simple chart that you can verbally explain in about ten-twenty seconds; forget about it. I use them to make sure that my analyses are good. But that's about as far as it goes. Unless your boss is a geek, know how to use it for your own skill at decision making. But expect that anyone else you are going to work with will think "Poisson" is a fish dish at a fancy French restaurant.
 
... But expect that anyone else you are going to work with will think "Poisson" is a fish dish at a fancy French restaurant.

It's not? :huh:
 
I'll use Regression from time to time when I'm doing financial forecasting (mixing threads here, I know, one aspect of my career in Finance).

At one point I recognized a series of polynomials consistently occurring in our business year over year, with a touch of growth, and perhaps the odd anomaly.

So, I decided I wanted to describe these series of constant curves mathematically, for top-down forecasting.

Nice functionality, and the price was right! :)
 
Thanks for all the responses guys. I think i'll try to keep up with it so I can use it in the future.
 

Forum statistics

Threads
1,222,729
Messages
6,167,881
Members
452,152
Latest member
PinHeads

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top