Research Management Statistical Applications Assignment | Homework Help Websites

answer the 2 questions in the attachment. Please provide the answers in an excel format.

Resource: Bowerman, Bruce J., Murphree, Emily S., O’Connell, Richart T, and Orris, J.B., Essentials of Business Statistics 5th ed. McGraw-Hill: 2015. IBSN: 978-0-07-802053-7

Assignment 1

 Please answer the following questions using Excel. 

Q.1 1.7 The number of Bismark X-12 electronic calculators sold at Smith’s Department

Stores over the past 24 months have been: 197, 211, 203, 247, 239, 269, 308, 262,

258, 256, 261, 288, 296, 276, 305, 308, 356, 393, 363, 386, 443, 308, 358, and 384.

Make a time series plot of these data in excel. That is, plot 197 versus month 1, 211 versus month 2, and so forth. What does the time series plot tell you?

Exercises for Sections 1.1. and 1.2 (Chapter 1)

Q.2.You have a list of repeating group names given below. Organize the data graphically in a pivot table and a pivot chart in excel to show the frequency of occurrence of each group name.