1. Answers MUST BE NICELY TYPED in a Microsoft Word document. Times New Roman, 12pt font is highly recommended.
2. The document must have 1 inch margin all around on all pages. All pages must be numbered.
3. The cover page of the submission must include your name, T-Number, class and section number.
4. The Word document must be uploaded by no later than 11:30 PM, September 16, 2020 into the Examination 1 folder inside the eLearn Dropbox. This is the ONLY WAY a valid submission can be made.
5. Save this final Word file with the following name convention: firstname-lastname-ECON3050- Exam-1.docx. For example: John-Doe-ECON3050-Exam-1.docx. Then upload the file to the submission folder BEFORE the deadline.
6. Late Submissions WILL NOT be accepted. Early submissions are welcome and strongly encouraged.
7. Photographs of handwritten work, and email submissions WILL NOT BE ACCEPTED.
8. No hard copy submission is allowed.
9. Each submission will be subjected to a strict plagiarism test. Submissions failing the plagiarism test will automatically earn a failing grade in the examination. NO EXCEPTIONS.
10. All supporting data and calculations MUST BE UPLOADED alongside the Word File. The data work must be in a Microsoft Excel format.
1. Introduction to Business Statistics
2. Data types and measurement
3. Calculating descriptive statistics
4. Displaying descriptive statistics
5. Sampling and Sampling Distribution
6. One Sample Hypothesis Tests
7. Two sample hypothesis test
8. Hypothesis test concerning variance
9. Analysis of Variance - One way
• Read the chapters of the book.
• Read the lecture notes posted on eLearn.
• Visit the additional materials section and read the Basic Statistics Handout.
• Watch the lecture videos posted inside the eLearn
The resources are provided so that you can perform your analysis on two largely comparable plat- forms: Microsoft Excel and Google Sheets.
You need to choose between Microsoft Excel or Google Sheets as your preferred ana- lytics platform but it will be entirely fine to learn BOTH.
The videos are referred as learning materials. No product, opinion, advertisement, etc. is en- dorsed. YOU ARE STRONGLY ADVISED TO IGNORE ANY COMMERCIAL MA- TERIAL THAT IS NOT RELETED TO FORMULAS AND CONCEPTS COVERED
IN THE COURSE. Please bring to my attention if you notice any inappropriate material.
1. For Microsoft Windows: How to Install the Data Analysis ToolPak in Microsoft Excel
2. For Mac: How to Install the Data Analysis ToolPak in Microsoft Excel
3. Creating Pivot Tables in Excel
4. Excel - One-Way ANOVA Analysis Toolpack
5. F Test in Excel
1. Installing the XLMiner Analysis ToolPak add-on in Google Sheets
2. Google Sheets: Create Pivot Tables and Charts
3. Two Way ANOVA - with Google Sheets XL-miner
4. Running a t-Test using Google Sheets
5. Using Google Sheets to Calculate Differences in Proportions (Z Test)
Note: Solve each of these problems in the traditional way, paper and pencil. Then nicely type your answers in the Word document that will be submitted. DO NOT submit the images of the handwritten work docuements.
(a) Compute the arithmatic mean, geometric mean, median, variance, standard deviation, skewness, maximum, minimum, inter-quartile range, 90 th percentile, 75 th percentile, 95% confidence interval for population mean, 90% confidence interval for population mean, and 95% confidence interval for population mean for Sample A.
(b) Compute the arithmatic mean, geometric mean, median, variance, standard deviation, skewness, maximum, minimum, inter-quartile range, 90 th percentile, 75 th percentile, 95% confidence interval for population mean, 90% confidence interval for population mean, and 95% confidence interval for population mean for Sample B.
(c) Test the hypothesis that the populations from which the two samples have been drawn have the same mean. Precisely state the hypothesis in terms of H0 and H1 and the test statistic to be used for this hypothesis test.
(d) Test the hypothesis that the populations from which the two samples have been drawn have means whose difference is no more than 3. Precisely state the hypothesis in terms of H0 and H1 and the test statistic to be used for this hypothesis test.
(e) Test the hypothesis that the populations from which the two samples have been drawn have means whose difference is no less than 4. Precisely state the hypothesis in terms of H0 and H1 and the test statistic to be used for this hypothesis test.
(a) Compute the arithmatic mean, geometric mean, median, variance, standard deviation, skewness, maximum, minimum, inter-quartile range, 90 th percentile, 75 th percentile, 95% confidence interval for population mean, 90% confidence interval for population mean, and 95% confidence interval for population mean for Sample A.
(b) Compute the arithmatic mean, geometric mean, median, variance, standard deviation, skewness, maximum, minimum, inter-quartile range, 90 th percentile, 75 th percentile, 95% confidence interval for population mean, 90% confidence interval for population mean, and 95% confidence interval for population mean for Sample B.
(c) Test the hypothesis that the populations from which the two samples have been drawn have the same mean. Precisely state the hypothesis in terms of H0 and H1 and the test statistic to be used for this hypothesis test.
(d) Test the hypothesis that the populations from which the two samples have been drawn have means whose difference is no more than 3. Precisely state the hypothesis in terms of H0 and H1 and the test statistic to be used for this hypothesis test.
(e) Test the hypothesis that the populations from which the two samples have been drawn have means whose difference is no less than 4. Precisely state the hypothesis in terms of H0 and H1 and the test statistic to be used for this hypothesis test.
Sample A: {18, 18, 30, 23, 25, 29, 17, 11, 24, 23} and Sample B: {15, 33, 27, 7, 17, 19, 23, 20, 45, 25, 35}.
Test the hypothesis that the two populations from which these two samples have been drawn have the same mean and same variance.
Sample A: {10, 21, 30, 29, 29, 30, 27, 11, 29, 29} and Sample B: {11, 13, 14, 22, 21, 17, 24, 29, 31, 26, 11}.
Test the hypothesis that the two populations from which these two samples have been drawn have the same mean and same variance.
Sample A: {71, 71, 92, 73, 85, 75, 99, 78, 85, 85} and Sample B: {88, 86, 92, 98, 76, 98, 75, 88, 92, 85, 88}.
Test the hypothesis that the two populations from which these two samples have been drawn have the same mean and same variance.
Hint: If two populations have the same mean then the differennce between their means is 0. If two populations have the same variance then the differennce between their variances is 0 too.
5.1. Prepare the Dataset in Excel Format
Visit and scroll down to find the statewise COVID-19 data for all states in the USA. Input this data in a new working dataset. This should be a Microsoft Excel dataset.
Augment the data by creating two addtional columns denoting the census (i) region & (ii) division that the states fall under. That information is avilable from regdiv.pdf
Save this final dataset with the following name convention: firstname-lastname-ECON3050- Exam-1.xlsx. For example: John-Doe-ECON3050-Exam-1.xlsx
Once the data analysis is done on this dataset, only the final results should be reported
in the Word file. Upload both the data file and the Word file as your submission.
5.2. Answer the Data Analysis Questions Using the Excel File
Note: Do the data analysis in the Microsoft Excel file and write your final asnwers in the Microsoft Word submission file.
1. Make a pie chart capturing the distribution of COVID-19 cases in various census regions.
2. Make a pie chart capturing the distribution of COVID-19 deaths in various census regions.
3. Make a pie chart capturing the distribution of COVID-19 cases in various census divisions.
4. Make a pie chart capturing the distribution of COVID-19 deaths in various census divisions.
5. Make a pie chart capturing the distribution of COVID-19 tests in various census divisions.
6. Make a pie chart capturing the distribution of COVID-19 tests in various census divisions.
7. Make a bar chart and a histogram capturing the distribution of COVID-19 cases in various census regions.
8. Make a bar chart and a histogram capturing the distribution of COVID-19 deaths in various census regions.
9. Make a bar chart and a histogram capturing the distribution of COVID-19 cases in various census divisions.
10. Make a bar chart and a histogram capturing the distribution of COVID-19 deaths in various census divisions.
11. Make a bar chart and a histogram capturing the distribution of COVID-19 tests in various census divisions.
12. Make a bar chart and a histogram capturing the distribution of COVID-19 tests in various census divisions.
13. Test the hypothesis that the differences in the means of COVID-19 deaths per million popu- lation is same between Northeast and Midswest Regions.
14. Test the hypothesis that the differences in the means of COVID-19 deaths per million popu- lation is same between South and Midswest Regions.
15. Test the hypothesis that the differences in the means of COVID-19 deaths per million popu- lation is same between South and Northeast Regions.
16. Test the hypothesis that the differences in the means of COVID-19 deaths per million popu- lation is same between South and Midswest Regions.
17. Test the hypothesis that the differences in the means of COVID-19 deaths per million popu- lation is same between South and West Regions.
18. Test the hypothesis that the differences in the means of COVID-19 deaths per million popu- lation is same between West and Midswest Regions.
19. Test the hypothesis that the differences in the means of COVID-19 deaths per million popu- lation is same between West and Northeast Regions.
20. Test the hypothesis that the difference in the variances of COVID-19 deaths per million pop- ulation is same between Northeast and Midswest Regions.
21. Test the hypothesis that the difference in the variances of COVID-19 deaths per million pop- ulation is same between South and Midswest Regions.
22. Test the hypothesis that the difference in the variances of COVID-19 deaths per million pop- ulation is same between South and Northeast Regions.
23. Test the hypothesis that the difference in the variances of COVID-19 deaths per million pop- ulation is same between South and Midswest Regions.
24. Test the hypothesis that the difference in the variances of COVID-19 deaths per million pop- ulation is same between South and West Regions.
25. Test the hypothesis that the difference in the variances of COVID-19 deaths per million pop- ulation is same between West and Midswest Regions.
26. Test the hypothesis that the difference in the variances of COVID-19 deaths per million pop- ulation is same between West and Northeast Regions.
27. Check the hypothesis that means of COVID-19 deaths per million population is same between all regions.
28. Check the hypothesis that means of COVID-19 cases per million population is same between all regions.
29. Check the hypothesis that means of COVID-19 tests per million population is same between all regions.
30. Write a short essay (no more than 2 pages) describing the differences in COVID-19 cases, deaths, and deaths across regions. How difference are they. Is the pandemic affecting all parts of the country equally? What does the data say? How do the statistical tests help you reach the conclusion that you reached? Make sure your essay is easily understandable to an intelligent reader who may not have any training in statistics and quantitative methods. Feel free to support your arguments by summary tables, charts, graphs, etc
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
