Calculate the variance in your spreadsheet which are the Sum of Squares Deviatio

Question

Calculate the variance in your spreadsheet which are the Sum of Squares Deviations, and the variance. Compare your results with that from the Excel function VAR.P() and VAR.S().

    

Find the st. dev for Brand Value. Interpret the measure in the context. Hint: Don’t forget the plug the units back in.

Rank Brand Value 1 Apple 104.3 2 Microsoft 56.7 3 Coca-Cola 54.9 4 IBM 50.7 5 Google 47.3 6 McDonald's 39.4 7 General Electric 34.2 8 Intel 30.9 9 Samsung 29.5 10 Louis Vuitton 28.4 11 BMW 27.9 12 Cisco 27.0 13 Oracle 26.9 14 Toyota 25.6 15 AT&T 24.2 16 Mercedes-Benz 23.5 17 Disney 23.1 18 Wal-Mart 21.7 19 Budweiser 21.1 20 Honda 21.1 21 SAP 19.6 22 Verizon 19.3 23 Gillette 18.3 24 NIKE 18.2 25 Pepsi 18.1 26 American Express 18.0 27 Nescafe 17.7 28 L'Oréal 16.9 29 Marlboro 16.6 30 H&M 16.1 31 Hewlett-Packard 15.3 32 HSBC 15.2 33 Amazon.Com 14.7 34 Visa 14.2 35 Siemens 13.7 36 Facebook 13.7 37 ESPN 12.9 38 Gucci 12.1 39 Nestle 11.8 40 Frito-Lay 11.6 41 IKEA 11.5 42 Danone 11.1 43 Audi 10.9 44 Ford 10.6 45 Coach 10.5 46 Fox 10.2 47 UPS 10.2 48 Home Depot 10.1 49 Accenture 9.7 50 Thomson Reuters 9.6 51 Pampers 9.6 52 Zara 9.4 53 Hermès 9.3 54 J.P. Morgan 9.1 55 Kraft 9.1 56 Wells Fargo 9.0 57 Canon 8.7 58 Kellogg's 8.7 59 Ebay 8.5 60 Caterpillar 8.5 61 Adidas 8.4 62 Volkswagen 8.1 63 Ninendo 8.0 64 Colgate 7.9 65 Bank of America 7.7 66 Shell 7.6 67 Mastercard 7.4 68 Rolex 7.4 69 Red Bull 7.2 70 Prada 7.1 71 Philips 7.1 72 Nokia 7.0 73 Lexus 7.0 74 Chanel 7.0 75 Heineken 7.0 76 Starbucks 6.9 77 Allianz 6.9 78 Nissan 6.9 79 Goldman Sachs 6.8 80 Sony 6.6 81 Hyundai 6.5 82 Exxon Mobil 6.4 83 John Deere 6.4 84 Dell 6.4 85 Boeing 6.4 86 Ralph Lauren 6.4 87 Chase 6.3 88 Lancome 6.2 89 Santander 6.0 90 Ericsson 5.9 91 FedEx 5.8 92 Subway 5.7 93 ING 5.7 94 Credit Suisse 5.7 95 Porsche 5.7 96 Heinz 5.6 97 AXA 5.6 98 MTV 5.6 99 Burberry 5.5 100 Estee Lauder 5.4

Explanation / Answer

Sol:

To find sample variance:

find sample mean bbar

subtract each brand value from mean

square it

divide by n-1 to get sample variance

using formula in excel

It is matching to sample variance var.s.

since variance is large are more spread apart.

Rank Brand brandValue(b) mean(bbar) b-bbar (b-bar)^2 1 Apple 104.3 14.919 89.381 7988.963 2 Microsoft 56.7 14.919 41.781 1745.652 3 Coca-Cola 54.9 14.919 39.981 1598.48 4 IBM 50.7 14.919 35.781 1280.28 5 Google 47.3 14.919 32.381 1048.529 6 McDonald's 39.4 14.919 24.481 599.3194 7 General Electric 34.2 14.919 19.281 371.757 8 Intel 30.9 14.919 15.981 255.3924 9 Samsung 29.5 14.919 14.581 212.6056 10 Louis Vuitton 28.4 14.919 13.481 181.7374 11 BMW 27.9 14.919 12.981 168.5064 12 Cisco 27 14.919 12.081 145.9506 13 Oracle 26.9 14.919 11.981 143.5444 14 Toyota 25.6 14.919 10.681 114.0838 15 AT&T 24.2 14.919 9.281 86.13696 16 Mercedes-Benz 23.5 14.919 8.581 73.63356 17 Disney 23.1 14.919 8.181 66.92876 18 Wal-Mart 21.7 14.919 6.781 45.98196 19 Budweiser 21.1 14.919 6.181 38.20476 20 Honda 21.1 14.919 6.181 38.20476 21 SAP 19.6 14.919 4.681 21.91176 22 Verizon 19.3 14.919 4.381 19.19316 23 Gillette 18.3 14.919 3.381 11.43116 24 NIKE 18.2 14.919 3.281 10.76496 25 Pepsi 18.1 14.919 3.181 10.11876 26 American Express 18 14.919 3.081 9.492561 27 Nescafe 17.7 14.919 2.781 7.733961 28 L'Oréal 16.9 14.919 1.981 3.924361 29 Marlboro 16.6 14.919 1.681 2.825761 30 H&M 16.1 14.919 1.181 1.394761 31 Hewlett-Packard 15.3 14.919 0.381 0.145161 32 HSBC 15.2 14.919 0.281 0.078961 33 Amazon.Com 14.7 14.919 -0.219 0.047961 34 Visa 14.2 14.919 -0.719 0.516961 35 Siemens 13.7 14.919 -1.219 1.485961 36 Facebook 13.7 14.919 -1.219 1.485961 37 ESPN 12.9 14.919 -2.019 4.076361 38 Gucci 12.1 14.919 -2.819 7.946761 39 Nestle 11.8 14.919 -3.119 9.728161 40 Frito-Lay 11.6 14.919 -3.319 11.01576 41 IKEA 11.5 14.919 -3.419 11.68956 42 Danone 11.1 14.919 -3.819 14.58476 43 Audi 10.9 14.919 -4.019 16.15236 44 Ford 10.6 14.919 -4.319 18.65376 45 Coach 10.5 14.919 -4.419 19.52756 46 Fox 10.2 14.919 -4.719 22.26896 47 UPS 10.2 14.919 -4.719 22.26896 48 Home Depot 10.1 14.919 -4.819 23.22276 49 Accenture 9.7 14.919 -5.219 27.23796 50 Thomson Reuters 9.6 14.919 -5.319 28.29176 51 Pampers 9.6 14.919 -5.319 28.29176 52 Zara 9.4 14.919 -5.519 30.45936 53 Hermès 9.3 14.919 -5.619 31.57316 54 J.P. Morgan 9.1 14.919 -5.819 33.86076 55 Kraft 9.1 14.919 -5.819 33.86076 56 Wells Fargo 9 14.919 -5.919 35.03456 57 Canon 8.7 14.919 -6.219 38.67596 58 Kellogg's 8.7 14.919 -6.219 38.67596 59 Ebay 8.5 14.919 -6.419 41.20356 60 Caterpillar 8.5 14.919 -6.419 41.20356 61 Adidas 8.4 14.919 -6.519 42.49736 62 Volkswagen 8.1 14.919 -6.819 46.49876 63 Ninendo 8 14.919 -6.919 47.87256 64 Colgate 7.9 14.919 -7.019 49.26636 65 Bank of America 7.7 14.919 -7.219 52.11396 66 Shell 7.6 14.919 -7.319 53.56776 67 Mastercard 7.4 14.919 -7.519 56.53536 68 Rolex 7.4 14.919 -7.519 56.53536 69 Red Bull 7.2 14.919 -7.719 59.58296 70 Prada 7.1 14.919 -7.819 61.13676 71 Philips 7.1 14.919 -7.819 61.13676 72 Nokia 7 14.919 -7.919 62.71056 73 Lexus 7 14.919 -7.919 62.71056 74 Chanel 7 14.919 -7.919 62.71056 75 Heineken 7 14.919 -7.919 62.71056 76 Starbucks 6.9 14.919 -8.019 64.30436 77 Allianz 6.9 14.919 -8.019 64.30436 78 Nissan 6.9 14.919 -8.019 64.30436 79 Goldman Sachs 6.8 14.919 -8.119 65.91816 80 Sony 6.6 14.919 -8.319 69.20576 81 Hyundai 6.5 14.919 -8.419 70.87956 82 Exxon Mobil 6.4 14.919 -8.519 72.57336 83 John Deere 6.4 14.919 -8.519 72.57336 84 Dell 6.4 14.919 -8.519 72.57336 85 Boeing 6.4 14.919 -8.519 72.57336 86 Ralph Lauren 6.4 14.919 -8.519 72.57336 87 Chase 6.3 14.919 -8.619 74.28716 88 Lancome 6.2 14.919 -8.719 76.02096 89 Santander 6 14.919 -8.919 79.54856 90 Ericsson 5.9 14.919 -9.019 81.34236 91 FedEx 5.8 14.919 -9.119 83.15616 92 Subway 5.7 14.919 -9.219 84.98996 93 ING 5.7 14.919 -9.219 84.98996 94 Credit Suisse 5.7 14.919 -9.219 84.98996 95 Porsche 5.7 14.919 -9.219 84.98996 96 Heinz 5.6 14.919 -9.319 86.84376 97 AXA 5.6 14.919 -9.319 86.84376 98 MTV 5.6 14.919 -9.319 86.84376 99 Burberry 5.5 14.919 -9.419 88.71756 100 Estee Lauder 5.4 14.919 -9.519 90.61136 sample variance=19669.49/100-1 =19669.49/99 =198.6817

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.