Excel Data Analysis for Dummies.

Intro -- Title Page -- Copyright Page -- Table of Contents -- Introduction -- About This Book -- What You Can Safely Ignore -- What You Shouldn't Ignore (Unless You're a Masochist) -- Foolish Assumptions -- How This Book Is Organized -- Beyond the Book -- Where to Go from Here -- Part I Getting Started with Data Analysis -- Chapter 1 Introducing Excel Tables -- What Is a Table and Why Do I Care? -- Building Tables -- Exporting from a database -- Building a table the hard way -- Building a table the semi‐hard way -- Analyzing Table Information -- Simple statistics -- Sorting table records -- Using AutoFilter on a table -- Undoing a filter -- Turning off filter -- Using the custom AutoFilter -- Filtering a filtered table -- Using advanced filtering -- Chapter 2 Grabbing Data from External Sources -- Getting Data the Export‐Import Way -- Exporting: The first step -- Importing: The second step (if necessary) -- Querying External Databases and Web Page Tables -- Running a web query -- Importing a database table -- Querying an external database -- It's Sometimes a Raw Deal -- Chapter 3 Scrub‐a‐Dub‐Dub: Cleaning Data -- Editing Your Imported Workbook -- Delete unnecessary columns -- Delete unnecessary rows -- Resize columns -- Resize rows -- Erase unneeded cell contents -- Format numeric values -- Copying worksheet data -- Moving worksheet data -- Replacing data in fields -- Cleaning Data with Text Functions -- What's the big deal, Steve? -- The answer to some of your problems -- The CLEAN function -- The CONCATENATE function -- The EXACT function -- The FIND function -- The FIXED function -- The LEFT function -- The LEN function -- The LOWER function -- The MID function -- The PROPER function -- The REPLACE function -- The REPT function -- The RIGHT function -- The SEARCH function -- The SUBSTITUTE function -- The T function -- The TEXT function.

The TRIM function -- The UPPER function -- The VALUE function -- Converting text function formulas to text -- Using Validation to Keep Data Clean -- Part II PivotTables and PivotCharts -- Chapter 4 Working with PivotTables -- Looking at Data from Many Angles -- Getting Ready to Pivot -- Running the PivotTable Wizard -- Fooling Around with Your Pivot Table -- Pivoting and re‐pivoting -- Filtering pivot table data -- Using a slicer or timeline -- Refreshing pivot table data -- Sorting pivot table data -- Pseudo‐sorting -- Grouping and ungrouping data items -- Selecting this, selecting that -- Where did that cell's number come from? -- Setting value field settings -- Customizing How Pivot Tables Work and Look -- Setting pivot table options -- Formatting pivot table information -- Chapter 5 Building PivotTable Formulas -- Adding Another Standard Calculation -- Creating Custom Calculations -- Using Calculated Fields and Items -- Adding a calculated field -- Adding a calculated item -- Removing calculated fields and items -- Reviewing calculated field and calculated item formulas -- Reviewing and changing solve order -- Retrieving Data from a Pivot Table -- Getting all the values in a pivot table -- Getting a value from a pivot table -- Arguments of the GETPIVOTDATA function -- Chapter 6 Working with PivotCharts -- Why Use a Pivot Chart? -- Getting Ready to Pivot -- Running the PivotChart Wizard -- Fooling Around with Your Pivot Chart -- Pivoting and re‐pivoting -- Filtering pivot chart data -- Refreshing pivot chart data -- Grouping and ungrouping data items -- Using Chart Commands to Create Pivot Charts -- Chapter 7 Customizing PivotCharts -- Selecting a Chart Type -- Working with Chart Styles -- Changing Chart Layout -- Chart and axis titles -- Chart legend -- Chart data labels -- Chart data tables -- Chart axes -- Chart gridlines.

Changing a Chart's Location -- Formatting the Plot Area -- Formatting the Chart Area -- Chart fill patterns -- Chart area fonts -- Formatting 3‐D Charts -- Formatting the walls of a 3‐D chart -- Using the 3‐D View command -- Part III Advanced Tools -- Chapter 8 Using the Database Functions -- Quickly Reviewing Functions -- Understanding function syntax rules -- Entering a function manually -- Entering a function with the Function command -- Using the DAVERAGE Function -- Using the DCOUNT and DCOUNTA Functions -- Using the DGET Function -- Using the DMAX and DMAX Functions -- Using the DPRODUCT Function -- Using the DSTDEV and DSTDEVP Functions -- Using the DSUM Function -- Using the DVAR and DVARP Functions -- Chapter 9 Using the Statistics Functions -- Counting Items in a Data Set -- COUNT: Counting cells with values -- COUNTA: Alternative counting cells with values -- COUNTBLANK: Counting empty cells -- COUNTIF: Counting cells that match criteria -- COUNTIFS: Counting cells that match criteria -- PERMUT and PERMUTATIONA: Counting permutations -- COMBIN: Counting combinations -- Means, Modes, and Medians -- AVEDEV: An average absolute deviation -- AVERAGE: Average -- AVERAGEA: An alternate average -- AVERAGEIF and AVERAGEIFS: Selective averages -- TRIMMEAN: Trimming to a mean -- MEDIAN: Median value -- MODE: Mode values -- GEOMEAN: Geometric mean -- HARMEAN: Harmonic mean -- Finding Values, Ranks, and Percentiles -- MAX: Maximum value -- MAXA: Alternate maximum value -- MIN: Minimum value -- MINA: Alternate minimum value -- LARGE: Finding the kth largest value -- SMALL: Finding the kth smallest value -- RANK, RANK.AVG, and RANK.EQ: Ranking an array value -- PERCENTRANK.EXC and PERCENTRANK.INC: Finding a percentile ranking -- PERCENTILE.EXC and PERCENTILE.INC: Finding a percentile ranking -- QUARTILE.EXC and QUARTILE.INC: Finding a quartile ranking.

FREQUENCY: Frequency of values in a range -- PROB: Probability of values -- Standard Deviations and Variances -- STDEV.S: Standard deviation of a sample -- STDEVA: Alternate standard deviation of a sample -- STDEV.P: Standard deviation of a population -- STDEVPA: Alternate standard deviation of a population -- VAR.S: Variance of a sample -- VARA: Alternate variance of a sample -- VAR.P: Variance of a population -- VARPA: Alternate variance of a population -- COVARIANCE.P and COVARIANCE.S: Covariances -- DEVSQ: Sum of the squared deviations -- Normal Distributions -- NORM.DIST: Probability X falls at or below a given value -- NORM.INV: X that gives specified probability -- NORM.S.DIST: Probability variable within z‐standard deviations -- NORM.S.INV: z‐value equivalent to a probability -- STANDARDIZE: z‐value for a specified value -- CONFIDENCE: Confidence interval for a population mean -- KURT: Kurtosis -- SKEW and SKEW.P: Skewness of a distribution -- GAUSS: Probability a value falls within a range -- PHI: Density function of a normal distribution -- t‐distributions -- T.DIST: Left‐tail Student t‐distribution -- T.DIST.RT: Right‐tail Student t‐distribution -- T.DIST.2T: Two‐tail Student t‐distribution -- T.INV: Left‐tailed Inverse of student t‐distribution -- T.INV.2T: Two‐tailed Inverse of Student t‐distribution -- T.TEST: Probability two samples from same population -- f‐distributions -- F.DIST: Left‐tailed f‐distribution probability -- F.DIST.RT: Right‐tailed f‐distribution probability -- F.INV:Left‐tailed f‐value given f‐distribution probability -- F.INV.RT:Right‐tailed f‐value given f‐distribution probability -- F.TEST: Probability data set variances not different -- Binomial Distributions -- BINOM.DIST: Binomial probability distribution -- BINOM.INV: Binomial probability distribution -- BINOM.DIST.RANGE: Binomial probability of Trial Result.

NEGBINOM.DIST: Negative binominal distribution -- CRITBINOM: Cumulative binomial distribution -- HYPGEOM.DIST: Hypergeometric distribution -- Chi‐Square Distributions -- CHISQ.DIST.RT: Chi‐square distribution -- CHISQ.DIST: Chi‐square distribution -- CHISQ.INV.RT: Right‐tailed chi‐square distribution probability -- CHISQ.INV: Left‐tailed Chi‐square distribution probability -- CHISQ.TEST: Chi‐square test -- Regression Analysis -- FORECAST.LINEAR: Forecast dependent variables using a best‐fit line -- FORECAST.ETS: Forecast time values using exponential triple smoothing -- INTERCEPT: y‐axis intercept of a line -- LINEST -- SLOPE: Slope of a regression line -- STEYX: Standard error -- TREND -- LOGEST: Exponential regression -- GROWTH: Exponential growth -- Correlation -- CORREL: Correlation coefficient -- PEARSON: Pearson correlation coefficient -- RSQ: r‐squared value for a Pearson correlation coefficient -- FISHER -- FISHERINV -- Some Really Esoteric Probability Distributions -- BETA.DIST: Cumulative beta probability density -- BETA.INV: Inverse cumulative beta probability density -- EXPON.DIST: Exponential probability distribution -- GAMMA: Gamma function value -- GAMMA.DIST: Gamma distribution probability -- GAMMAINV: X for a given gamma distribution probability -- GAMMALN and GAMMALN.PRECISE: Natural logarithm of a gamma distribution -- LOGNORM.DIST: Probability of lognormal distribution -- LOGNORM.INV: Value associated with lognormal distribution probability -- POISSON.DIST: Poisson distribution probabilities -- WEIBULL: Weibull distribution -- ZTEST: Probability of a z‐test -- Chapter 10 Descriptive Statistics -- Using the Descriptive Statistics Tool -- Creating a Histogram -- Ranking by Percentile -- Calculating Moving Averages -- Exponential Smoothing -- Generating Random Numbers -- Sampling Data -- Chapter 11 Inferential Statistics.

Using the t‐test Data Analysis Tool.

Description based on publisher supplied metadata and other sources.

Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.