Use PivotTables to construct cross-tabulations between each pair of variables for the data provided. LOADING... Click the icon to view the soda preference data. Question content area bottom Part 1 Complete the cross-tabulation for Gender vs. Favorite Brand. (Type whole numbers.) Gender vs Favorite Brand Count of Consumption Time Column Labels Row Labels 7UP A&W Root Beer Coke Dr Pepper Mountain Dew Other Pepsi Sunkist Grand Total Female enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here Male enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here Grand Total enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here Gender Favorite Brand Consumption Time Male Dr Pepper Afternoon Female Sunkist Morning Male Coke Afternoon Female Other Afternoon Female Coke Night Female A&W Root Beer Afternoon Male Mountain Dew Afternoon Female A&W Root Beer Evening Male Other Night Male Mountain Dew Afternoon Female Pepsi Afternoon Female Other Afternoon Male Coke Night Female 7UP Morning Female Coke Night

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Question content area bottom

Part 1

Complete the cross-tabulation for Gender vs. Favorite Brand.

(Type whole numbers.)

Gender vs Favorite Brand

Count of Consumption Time	Column Labels
Row Labels	7UP	A&W Root Beer	Coke	Dr Pepper	Mountain Dew	Other	Pepsi	Sunkist	Grand Total
Female	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here
Male	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here
Grand Total	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here	enter your response here

Gender Favorite Brand Consumption Time
Male Dr Pepper Afternoon
Female Sunkist Morning
Male Coke Afternoon
Female Other Afternoon
Female Coke Night
Female A&W Root Beer Afternoon
Male Mountain Dew Afternoon
Female A&W Root Beer Evening
Male Other Night
Male Mountain Dew Afternoon
Female Pepsi Afternoon
Female Other Afternoon
Male Coke Night
Female 7UP Morning
Female Coke Night