Assignment
Statistics and Data Analysis
Businesses often survey their customers and employees to find out what they want and what they are doing. In the era of big data where everything is connected to the Internet and every devicecollects data, meaningful data analysis has become ever more important. Excel is a great tool to help managers decipher data and make sense out of it. Please read the following few articles to understand what surveys are and what Excel can do to help you analyze data.
https://www.surveymonkey.com/mp/business-surveys/ (from one of the most popular FREE online survey site)
https://www.willamette.edu/~dnegri/courses/econ230/Data_Analysis_Toolpack_Guide.pdf (brief introduction of Excel's Data Analysis functions)
In Excel, one would need to install the optional Data Analysis Tookpak to use these statistical tools. Once installed, one may choose Data, Data Analysis, then select the analysis you want done. It's that simple!
Assignment: Please recreate the spreadsheet per the PDF file using the shell provided. Be sure to use formulas in cells with blue figures. Use the data analysis tool to create the t-test and histogram results and the histogram chart. Modify the chart so that it looks pretty. Do the same for all survey questions then answer the following questions:
1. For question 2, are there significant differences between group 1 and group 0? How confident can we say that the two groups have different opinions about question 2?
2. How about questions 3, 4, and 5?
Attachment:- scm_350_assignment_5_.xlsx