varianceanalysis(英文版)-資料下載頁
2025-02-14 04:37本頁面
【正文】 ice)answer ()$ =Total VarianceAllocate covariance: $ 100%trans $ 74% 74% to transactionrev $ 26% 26% to revTotal Delta Trans ()$ 74% Regular trans variance plus allocation from covarianceTotal Delta Price ()$ 26% Regular rev variance plus allocation from covariance()$ 100% =total varianceSample SpreadsheetMore Than Two Component Variance Example28Variance AnalysisSample Spreadsheet More Than Two Component Variance Example29Variance AnalysisNow suppose the client wants to further understand what drives revenue per transaction. How would you plete this slide showing the split between the three revenue per transaction variables? Customer segment:More Than Two Component Variance ExampleRevenue Per TransactionSources of VarianceVariance Analysis (Revenue per Transaction)30Variance AnalysisSample Spreadsheet This spreadsheet further allocates revenue per transaction variance into types of product purchased.More Than Two Component Variance Example31Variance AnalysisVariance analysis showed that the primary difference between customer segments was how often they came to the store. Over 70% of the variance between A customers and the others was explained by transaction frequency.Drivers of Variance 26%74% 70%30%More Than Two Component Variance Example32Variance Analysis Revenue per transaction analysis was not very telling.Customer segment:Revenue per TransactionSources of VarianceVariance Analysis (Revenue per Transaction)33Variance AnalysisSummary ? What drives A customer behavior is the number of transactions they plete–so, Bain needs to help improve the frequency of transactions of B and C customers (assuming that A customers continue to remain loyal and that a retention strategy is therefore not the most leveraged work)34Variance AnalysisAgenda ?What is variance analysis??Linear variance – Ice Cream Co.?Two ponent variance analysis– Jesse’s Brewery?Variance analysis with more than two ponents– Boston Video?Key takeaways35Variance AnalysisKey Takeaways Variance analysis is a simple way of breaking down changes in a variable into their ponent parts, to yield business insightKnow how to set up a spreadsheet and variance analysis bees straightforwardOften we only look at two ponents at a time The basic approach is to change only one variable at a time and observe the effect on the totalCovariance explains the amount of variance that is attributable to the change of both variances (as opposed to one) and is normally split between variables in proportion to their variancesVariance analysis can be used in many instances to understand changes in a business and to drive strategic and tactical decisionmaking. Key points to remember are:36Variance Analysis演講完畢，謝謝觀看！
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號-1