Business Analytics, - (For Complete File Download link at the end of ...

Business Analytics, 3e James Evans

(Solutions Manual All Chapter)

(For Complete File Download link at the end of this File)

• / 4

Dealer Satisfaction This would best be done with PivotTables or Sort procedures that are covered in the next chapter.This exercise gives students practice at copying, pasting, and manipulating data in spreadsheets.

Survey Scale:0 1 2 3 4 5Sample

North AmericaSize Region Year 0 1 2 3 4 5 2014 1 0 2142211 50 North America2014 1 0 2 14 22 11 2015 0 0 2142014 50 South America2014 0 0 0 2 6 2 2016 1 1 1 83415 60 Europe 2014 0 0 1 3 7 4 2017 1 2 6123445 100 Pacific Rim 2014 0 0 1 2 2 0 2018 2 3 5154456 125Totals 1 0 4 21 37 17 North America2015 0 0 2 14 20 14 South America South America2015 0 0 0 2 6 2 2014 0 0 0 2 6 2 10 Europe 2015 0 0 1 2 8 4 2015 0 0 0 2 6 2 10 Pacific Rim 2015 0 0 1 1 3 0 2016 0 0 1 41114 30Totals 0 0 4 19 37 20 2017 0 1 1 31233 50 North America2016 1 1 1 8 34 15 2018 1 1 2 42260 90 South America2016 0 0 1 4 11 14 Europe 2016 0 0 1 2 15 7 Europe Pacific Rim 2016 0 0 1 1 3 1 2014 0 0 1 3 7 4 15 China 2016 0 0 0 1 0 0 2015 0 0 1 2 8 4 15Totals 1 1 4 16 63 37 2016 0 0 1 215 7 25 North America2017 1 2 6 12 34 45 2017 0 0 1 221 6 30 South America2017 0 1 1 3 12 33 2018 0 0 1 417 8 30 Europe 2017 0 0 1 2 21 6 Pacific Rim 2017 0 0 0 2 5 3 Pacific Rim China 2017 0 0 1 4 2 0 2014 0 0 1 2 2 0 5Totals 1 3 9 23 74 87 2015 0 0 1 1 3 0 5 North America2018 2 3 5 15 44 56 2016 0 0 1 1 3 1 6 South America2018 1 1 2 4 22 60 2017 0 0 0 2 5 3 10 Europe 2018 0 0 1 4 17 8 2018 0 0 1 2 7 2 12 Pacific Rim 2018 0 0 1 2 7 2 China 2018 0 0 1 5 8 2 China Totals 3 4 10 30 98 128

2016 0 0 0 1 0 0 1

2017 0 0 1 4 2 0 7

2018 0 0 1 5 8 2 16 2 / 4

End-User SatisfactionThis would best be done with PivotTables or Sort procedures that are covered in the next chapter.This exercise gives students practice at copying, pasting, and manipulating data in spreadsheets.

Survey Scale:012345Sample

North America012345Size Region Year 0 1 2 3 4 5 2014136153738 100 North America2014 1 3 6 15 37 38 2015124183540 100 South America2014 1 2 5 18 36 38 2016125173441 100 Europe 2014 1 2 4 21 36 36 2017024153346 100 Pacific Rim 2014 2 3 5 15 41 34 2018023153149 100Totals 5 10 20 69 150 146 North America2015 1 2 4 18 35 40 South America South America2015 1 3 6 17 36 37 2014125183638 100 Europe 2015 1 2 5 21 34 37 2015136173637 100 Pacific Rim 2015 1 2 7 15 41 34 2016026193736 100Totals 4 9 22 71 146 148 2017025203736 100 North America2016 1 2 5 17 34 41 2018025193737 100 South America2016 0 2 6 19 37 36 Europe 2016 1 1 4 26 37 31 Europe Pacific Rim 2016 1 2 5 16 40 36 2014124213636 100 China 2016 0 3 3 6 28 10 2015125213437 100Totals 3 10 23 84 176 154 2016114263731 100 North America2017 0 2 4 15 33 46 2017113174137 100 South America2017 0 2 5 20 37 36 2018012194533 100 Europe 2017 1 1 3 17 41 37 Pacific Rim 2017 0 2 4 17 40 37 Pacific Rim China 2017 1 2 2 4 30 11 2014235154134 100Totals 2 9 18 73 181 167 2015127154134 100 North America2018 0 2 3 15 31 49 2016125164036 100 South America2018 0 2 5 19 37 37 2017024174037 100 Europe 2018 0 1 2 19 45 33 2018013194235 100 Pacific Rim 2018 0 1 3 19 42 35 China 2018 0 1 1 3 31 14 China Totals 0 7 14 75 186 168

201603362810 50

201712243011 50

201801133114 50 3 / 4

Mower Test Functional Performance Number of failures54 Sample Observation 1 2 3 4 5 6 7 8

• Pass Fail Pass Pass Pass Pass Pass Pass
• Pass Fail Pass Pass Pass Pass Pass Pass
• Pass Pass Pass Pass Pass Pass Pass Pass
• Pass Pass Pass Pass Pass Pass Pass Pass
• Pass Pass Pass Pass Pass Pass Pass Pass
• Pass Pass Pass Pass Pass Pass Pass Pass
• Pass Pass Pass Pass Pass Pass Pass Pass
• Pass Pass Pass Pass Pass Pass Pass Pass
• Pass Pass Pass Pass Pass Pass Pass Pass

10 Pass Pass Pass Pass Pass Fail Pass Pass 11 Pass Pass Pass Pass Pass Pass Pass Pass 12 Pass Fail Pass Pass Pass Pass Pass Pass 13 Pass Pass Pass Pass Pass Pass Pass Pass 14 Pass Pass Pass Pass Pass Pass Pass Pass 15 Pass Pass Pass Pass Pass Pass Pass Pass 16 Pass Pass Pass Pass Pass Fail Pass Pass 17 Pass Pass Pass Pass Pass Pass Pass Pass 18 Pass Pass Pass Pass Fail Pass Pass Pass 19 Pass Pass Pass Pass Pass Pass Pass Pass 20 Pass Pass Pass Pass Pass Pass Pass Pass 21 Pass Pass Pass Pass Pass Fail Pass Pass 22 Pass Pass Pass Pass Pass Pass Pass Pass 23 Pass Pass Pass Pass Pass Pass Pass Pass 24 Pass Pass Pass Pass Pass Pass Pass Pass 25 Pass Pass Pass Pass Pass Pass Pass Pass 26 Pass Fail Pass Pass Pass Pass Pass Pass 27 Pass Pass Pass Pass Pass Pass Pass Pass 28 Pass Pass Pass Pass Pass Pass Pass Pass 29 Pass Pass Pass Pass Pass Pass Pass Pass 30 Pass Pass Pass Pass Pass Pass Pass Pass 31 Pass Pass Pass Pass Pass Pass Pass Pass 32 Pass Pass Pass Pass Pass Pass Pass Pass 33 Pass Pass Pass Pass Pass Pass Pass Pass 34 Pass Pass Pass Pass Pass Pass Pass Pass 35 Pass Pass Pass Pass Pass Pass Pass Pass 36 Pass Pass Pass Pass Pass Pass Pass Pass 37 Pass Pass Pass Pass Pass Pass Pass Pass 38 Pass Pass Pass Pass Pass Pass Pass Pass 39 Pass Pass Pass Pass Pass Pass Pass Pass 40 Pass Pass Pass Pass Pass Pass Pass Pass 41 Pass Pass Pass Pass Pass Pass Pass Pass 42 Pass Pass Pass Pass Pass Pass Pass Pass

• / 4