LEADER 05184nam 2200601 450 001 9910464768703321 005 20200520144314.0 010 $a1-118-41730-5 010 $a1-118-43935-X 035 $a(CKB)3710000000083383 035 $a(EBL)1629159 035 $a(SSID)ssj0001163422 035 $a(PQKBManifestationID)11652136 035 $a(PQKBTitleCode)TC0001163422 035 $a(PQKBWorkID)11164308 035 $a(PQKB)11573009 035 $a(MiAaPQ)EBC1629159 035 $a(Au-PeEL)EBL1629159 035 $a(CaPaEBR)ebr10827571 035 $a(CaONFJC)MIL576437 035 $a(OCoLC)868721135 035 $a(EXLCZ)993710000000083383 100 $a20140125h20142014 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $2rdacontent 182 $2rdamedia 183 $2rdacarrier 200 10$aMarketing analytics $edata-driven techniques with Microsoft Excel /$fWayne L Winston 210 1$aIndianapolis, Indiana :$cJohn Wiley & Sons, Incorporation,$d2014. 210 4$d©2014 215 $a1 recurso en línea (722 páginas) $cilustraciones 300 $aIncludes index. 311 $a1-118-37343-X 327 $aCover; Title Page; Copyright; Contents; Introduction; Part I Using Excel to Summarize Marketing Data; Chapter 1 Slicing and Dicing Marketing Data with PivotTables; Analyzing Sales at True Colors Hardware; Analyzing Sales at La Petit Bakery; Analyzing How Demographics Affect Sales; Pulling Data from a PivotTable with the GETPIVOTDATA Function; Summary; Exercises; Chapter 2 Using Excel Charts to Summarize Marketing Data; Combination Charts; Using a PivotChart to Summarize Market Research Surveys; Ensuring Charts Update Automatically When New Data is Added; Making Chart Labels Dynamic 327 $aSummarizing Monthly Sales-Force RankingsUsing Check Boxes to Control Data in a Chart; Using Sparklines to Summarize Multiple Data Series; Using GETPIVOTDATA to Create the End-of-Week Sales Report; Summary; Exercises; Chapter 3 Using Excel Functions to Summarize Marketing Data; Summarizing Data with a Histogram; Using Statistical Functions to Summarize Marketing Data; Summary; Exercises; Part II Pricing; Chapter 4 Estimating Demand Curves and Using Solver to Optimize Price; Estimating Linear and Power Demand Curves; Using the Excel Solver to Optimize Price 327 $aPricing Using Subjectively Estimated Demand CurvesUsing SolverTable to Price Multiple Products; Summary; Exercises; Chapter 5 Price Bundling; Why Bundle?; Using Evolutionary Solver to Find Optimal Bundle Prices; Summary; Exercises; Chapter 6 Nonlinear Pricing; Demand Curves and Willingness to Pay; Profit Maximizing with Nonlinear Pricing Strategies; Summary; Exercises; Chapter 7 Price Skimming and Sales; Dropping Prices Over Time; Why Have Sales?; Summary; Exercises; Chapter 8 Revenue Management; Estimating Demand for the Bates Motel and Segmenting Customers; Handling Uncertainty 327 $aMarkdown PricingSummary; Exercises; Part III Forecasting; Chapter 9 Simple Linear Regression and Correlation; Simple Linear Regression; Using Correlations to Summarize Linear Relationships; Summary; Exercises; Chapter 10 Using Multiple Regression to Forecast Sales; Introducing Multiple Linear Regression; Running a Regression with the Data Analysis Add-In; Interpreting the Regression Output; Using Qualitative Independent Variables in Regression; Modeling Interactions and Nonlinearities; Testing Validity of Regression Assumptions; Multicollinearity; Validation of a Regression; Summary 327 $aExercisesChapter 11 Forecasting in the Presence of Special Events; Building the Basic Model; Summary; Exercises; Chapter 12 Modeling Trend and Seasonality; Using Moving Averages to Smooth Data and Eliminate Seasonality; An Additive Model with Trends and Seasonality; A Multiplicative Model with Trend and Seasonality; Summary; Exercises; Chapter 13 Ratio to Moving Average Forecasting Method; Using the Ratio to Moving Average Method; Applying the Ratio to Moving Average Method to Monthly Data; Summary; Exercises; Chapter 14 Winter's Method; Parameter Definitions for Winter's Method 327 $aInitializing Winter's Method 330 $aHelping tech-savvy marketers and data analysts solve real-world business problems with Excel Using data-driven business analytics to understand customers and improve results is a great idea in theory, but in today's busy offices, marketers and analysts need simple, low-cost ways to process and make the most of all that data. This expert book offers the perfect solution. Written by data analysis expert Wayne L. Winston, this practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques. 606 $aMarketing research$xData processing 608 $aElectronic books. 615 0$aMarketing research$xData processing. 676 $a658.80072 700 $aWinston$b Wayne L$0145432 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910464768703321 996 $aMarketing analytics$92005245 997 $aUNINA