Microsoft Excel Statistical and Advanced Functions for Decision Making

Microsoft Excel Statistical and Advanced Functions for Decision Making

4.11 - 1251 ratings - Source



Perform various data analysis using statistical functions, filters and histograms! Learn all about pivot tables and pivot charts! Use the Solver and Goal Seek to find optimum results! Perform sales forecasting and various predictions using Excel's built-in functions! This book was written to help any users wanting to have a good grasp on the advanced functions and an analysis of the various statistical tools for the purpose of decision making. It goes further by introducing the concepts of filters, estimating and forecasting, data validation, conditional formatting, goal seek, using the solver, and finally, pivot tables and pivot charts. Many books have been written on Excel. However, this book explains most of the advanced functions and features in a rather simplified manner with plenty of screen captures wherever possible. New users and existing users on Excel will find this book handy.Instead of calculating some of these values manually, Excel can be used to calculate the goodnessoffit (R2) value for any ... is to transform the data to enable you to use linear regression to find a relationship between transformed variables.


Title:Microsoft Excel Statistical and Advanced Functions for Decision Making
Author: Palani Murugappan
Publisher:Lulu Press, Inc - 2015-07-20
ISBN-13:

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.

How it works:
  • 1. Register a free 1 month Trial Account.
  • 2. Download as many books as you like (Personal use)
  • 3. Cancel the membership at any time if not satisfied.


Click button below to register and download Ebook
Privacy Policy | Contact | DMCA