دانلود کتاب Data Analysis for Business Decision Making: A Laboratory manual

فهرست مطالب :

Cover Half-Title Title page Copyright Dedication Contents Preface Chapter 1 – SHAPING AND CLEANINGDATA Analysis Case 1.1 – Shaping the Data File Analysis Case 1.2 – Cleaning the Data File Chapter 2 – INSTALLING THE ANALYSISTOOLPAK Analysis Case 2.1 – Excel Analysis ToolPak Installation and Activation Chapter 3 – DESCRIPTIVE STATISTICS Analysis Case 3.1 – Descriptive Statistics Five-Point Summaries Analysis Case 3.2 – Additional Analysis Case Using theORDERS File Analysis Case 3.3 – Descriptive Statistics Tabulation and Pivot Tables Analysis Case 3.4 – Additional Case Using Titanic Data Analysis Case 3.5 – Additional Case Using SFO AirportSurvey Data Chapter 4 – HISTOGRAMS Analysis Case 4.1 – Histograms Frequency Distributions Analysis Case 4.2 – Additional Case Using Titanic Data Chapter 5 – PARE TO ANALYSIS Analysis Case 5.1 – Pareto Analysis Which Are the Most Important? Analysis Case 5.2 – Additional Case Using MOVIES Data Analysis Case 5.3 – Additional Case Using ORDERS Analysis Case 5.4 – Additional Case Using SFO AirportSurvey Data Chapter 6 – SCATTER PLOTS Analysis Case 6.1 – Scatter Plots and 2x2 Analysis Which Are the “Best”? Analysis Case 6.2 – Additional Case Using World Bank Data Analysis Case 6.3 – Additional Case Using SFO AirportSurvey Data Chapter 7 – CORRELATION AND LINEARREGRESSION Analysis Case 7.1 – Correlation and Linear Regression How Are the Variables Related? Analysis Case 7.2 – Additional Case Using ORDERS Analysis Case 7.3 – Additional Case Using SFO AirportSurvey Data Chapter 8 – MULTIVARIATE REGRESSION Analysis Case 8.1 – Multivariate Regression Predictive Modeling Analysis Case 8.2 – Additional Case Using SFO AirportSurvey Data Chapter 9 – FORECASTING AND TIMESERIES Analysis Case 9.1 – Forecasting and Time Series Predicting Trends and Future Values Analysis Case 9.2 – Additional Case Using ORDERS Analysis Case 9.3 – Additional Case Using MOVIES Analysis Case 9.4 – Additional Forecasting Case Study Chapter 10 – INFERENTIAL STATISTICS Analysis Case 10.1 – Assurance of Results Inferential Statistics Analysis Case 10.2 – Additional Case Using FOOTBALLTRIALS Analysis Case 10.3 – Additional Exercise Using SFO AirportSurvey Data Chapter 11 – CONTINGENCY ANALYSIS Analysis Case 11.1 – Contingency Analysis and Chi-Squared Test of Variable Independence Analysis Case 11.2 – Additional Case Using SFO AirportSurvey Data Chapter 12 – A/B TESTING Analysis Case 12.1 – Design and Analysis of Trials A/B Testing Analysis Case 12.2 – Additional Case Using ORDERS Analysis Case 12.3 – Additional Case Using SFO AirportSurvey Data Analysis Case 12.4 – Additional Analysis Cases Using TitanicData Chapter 13 – TEX T ANALY TICS Analysis Case 13.1 – Unstructured Text Analysis I Analysis Case 13.2 – Unstructured Text Analysis II Using Excel for Sentiment Analysis Chapter 14 – ANALYZING BIG DATA SETS Analysis Case 14.1 – Big Data Analysis Using Sampling to Work with Large Data Files Analysis Case 14.2 – Additional Case Using theBankComplaints Big Data File Chapter 15 – DATA VISUALIZATION The Case The Analysis Template Analysis Case 15.1 – Story Create a Visual Story − Is the point of the visual very clear? Make It a Prop − Has the visual has been simplified and focused? Emulate Legendary Storytellers − Are past masters and the basiccharts that they pioneered emulated? Case Analysis Analysis Case 15.2 – Signs Give Them a Sign − Is the use of signs and symbols appropriate? It’s Like a Communication System − Is the signal-to-noise ratio high? Design for Function − Is the chart functionally informational ratherthan beautiful art? Case Analysis Analysis Case 15.3 – Purpose Consider the Information Need – Does the chart fulfill organizationalinformation needs? Consider the Audience – Does the chart allow for audience biases,needs, and journeys? Answer Well-Framed Analytical Questions – Does the visual answera well-framed analytical question? Case Analysis Analysis Case 15.4 – Perception Use the Eye-Brain System of Seeing – Does the eye of the viewer focuson the most important point being made? Employ the Gestalt Principles of Perception – Have the principles ofthe Gestalt psychology of perception been thoughtfully employed in thevisual? Design with Quality – Does the visual inform the viewer and dispel hisignorance? Case Analysis Analysis Case 15.5 – Method Use Color Effectively – Is color used judiciously and sparsely? Remove All Chart Junk – Is the visual is clear of unnecessary visualelements not leading to a clear point being made? Tell the Story with the Title – Does the title of the chart convey thepoint being made with the chart? Case Analysis Analysis Case 15.6 – Charts Use the Right Chart – Does the type of chart being used match the levelof judgment required? Select the Chart Type Effectively – Does the chart type used match thebusiness question being answered? Enhance Table Data for Emphasis – Are referenceable visuals(tables) readable with appropriate conditional formatting andthumbnail graphs used for emphasis? Case Analysis Analysis Case 15.7 – Putting It All Together A Possible Solution Chapter 16 – SUMMARY OF ANALYSISTECHNIQUES Business Questions and Analysis Techniques for Addressing Them Data Sources INDEX