Category: Statistics

In a word doc, with all numbers answered. please use a sample size of 110. do not forget tables, for #3 use a cumulative percentage for #4 use a line graphs. I can provide PowerPoints if everything we’ve learned so that it corresponds with our learning.

1st document: The Questions file contains the questions I got wrong. Use the attached zip folder to explain why I got the answer wrong and say which document you got it from. You have to use the attached documents in the zip to explain why I got the answer wrong and put what the correct answer is. The professor said “Take a screenshot of every question you have missed. Paste it to a word document. You may google or search YouTube if you do not know how to make a screenshot. Below each question explain why you now realize how you got the answer incorrect. Every question on the exam has an explanation on how it should be answered on the final exam discussion board or one of my exam keys provided with most homework assignments. ”
I also attached my exam discussion board.
2nd document: In order to receive credit for this discussion board you must carry-out an SPSS analysis, post it here and then interpret the findings. Or, you may also post two word problems with answers and explanation for credit (two word problems on the SAME post).
Put the 1st and 2nd documents in separate documents
This is 2 assignments for students, please make them completely different.

Show your working for the 4 questions step by step. Write down on a piece of paper and upload the photos or write on the document itself but make sure to show all the steps.

1. Analyse, interpret and present numerical data (including a range of advanced statistical tests via statistical software SPSS. I did run the software myself and I have got the DATA results already.  You must analyse the data using a multiple regression and write up a research report. You will need to develop a rationale for examining the topic of their choice, and analyse, present, and interpret the data. two APA tables, 2000 words report.

___________________________________________________________________
Quantitative Methods (STAT-201)
Assignment 3: Excel QM (Social-Responsible)
2nd Semester, 1444-1445 (2023-2024)
Due date: 06 May 2024 (Time: 11:00 PM)
Student’s Name
Student’s ID
Section/CRN
Location
Marking Scheme
Question
Score
Obtained Score
Q-1
2
Q-2
2
Q-3
2
Q-4
2
Note: You are required to fill your full name, ID, and CRN.
Message: Social responsibility is a framework of ethics in which an individual collaborates and works with other organizations and individuals for the betterment of the community. There are numerous ways in which an organization can exhibit social responsibility; for instance, by promoting volunteerism, facilitating donations, employing ethical employment practices, and implementing environmental improvements. It introduces the subjective obligation that entails maintaining a delicate equilibrium between one’s ecosystem and the economy, as well as the potential compromises that may be made between economic progress and societal and environmental wellbeing. This transcends business organizations and affects all individuals whose actions influence the environment.
Solve the following questions using Excel QM. (2×4 = 8 marks)
Helping others through blood donation is a form of social solidarity or social responsibility. The blood donors cite a sense of social responsibility as their reason for donating blood, and as a result, the communities value and reward this activity. The following table shows the number of blood donors in a university from 2011–2023. Develop a 3-year moving average forecast and obtain the related statistical measures using excel QM. University X has a unique on-campus dispensary that provides medical care. On a typical working day, patients arrive at the dispensary at an average rate of 2 patients per hour. There is one single nurse at the dispensary, and the average time required to give a consultation is 12 minutes.
Assume that you are a statistical consultant and want to provide a volunteer consultation to a start-up company as a social responsibility consultation. The company is planning to purchase a uniform outfit for their employees, and they obtained the following quantity discount table with three discount options:
To help needy people through charity is a form of social responsibility. The act of doing charity to help others is recognized and rewarded by all communities of the society. The following table shows the amount collected through charity and the amount spent on social development (in million dollars) in the last 8 years. Find the correlation and coefficient of determination for the given data and obtain the related statistical measures using excel QM.
year
Blood Donors
2011
116
2012
105
2013
146
2014
159
2015
108
2016
194
2017
227
2018
219
2019
234
2020
224
2021
248
2022
253
2023
265
2024
311
Solution:
It is assumed that the service times can be described by the exponential distribution, and the arrival process by a Poisson distribution. You are requested to find:
The average time in line,
The average number of patients in line,
The average time in the system,
The average number of patients in the system,
The probability that the dispensary is empty,
The utilization factor of the system.
Solution:
DISCOUNT NUMBER
DISCOUNT QUANTITY
DISCOUNT COST (SAR)
1
0 to 49
100
2
50 to 99
90
3
100 and over
85
Annual demand is 400 outfits, ordering cost is 50, and holding cost is 25% of the cost of the outfit. Use Excel QM to find the discount option with the minimum total cost.
Solution: Year
Amount collected(y)
Amount spent(x)
1
18
15
2
14
10
3
12
9
4
15
12
5
10
5
6
8
4
7
9
6
8
6
3
Solution:

This assignment will focus on learning how to create a pie chart, a Histogram, and a boxplot. For the last two tasks, you will choose the best way to visualize the data and then create the graph. Each task is worth 10 points. See the attached Excel document at the bottom of this assignment for the data sets. Each task’s data set is separated into it’s own sheet.
Task 1: Pie charts can be used to visualize categorical data. To create a pie chart, you need a well-defined population that can be split into pieces. For this question, you will look at the United States population divided by race and use the provided data to create a pie chart. You will create a pie chart with a title, legend, data labels and a source. Follow the video tutorials and instructions from the instructional materials for creating a pie chart in Excel. Copy the chart into a Word document and then type “Source: US Census Bureau” under the graph.
Task 2: Histograms can be used to visualize numerical data. To create a histogram, you must have numerical data. Histograms will be created using Excel or StatCrunch. Create a histogram using the provided dataset and following the video tutorials and instructions from the instructional materials. Paste the histogram in the same Word document and then type “Source: Unknown” under the graph.
Task 3: Boxplots can also be used to visualize numerical data. They can be used to compare two or more groups of data. Use the provided data to create two boxplots comparing Sqft grouped by location in Excel or StatCrunch. Paste the boxplot in the same Word document and then type “Source: Unknown” under the graph. If using StatCrunch, here is a direct link to the data for Task 3. (Make sure you are signed in)
Tasks 4 & 5: Make a graph that best visualizes each of the two provided datasets. Be sure to include details such as a title, data labels (if applicable), x-axis and y-axis labels (if applicable), legend (if applicable), and source. CriteriaLevel 4Level 3
Level 2
Level 1
Criterion Score
General
20 points
All questions are answered with minimal grammar/spelling errors. Explanations are well articulated. Correct mathematical notation is used. Written/visual analysis shows an understanding of descriptive/inferential statistics.
14 points
A few answers may have grammar/spelling errors. Explanations are included but may be missing some details. Possibly some errors using mathemetical notation. Written/visual analysis shows some understanding of descriptive/inferential statistics.
6 points
Answer have grammar/spelling errors. Explanations are included but have details missing. Errors in mathematical notation. Written/visual analysis shows a minimal understanding of descriptive/inferential statistics.
0 points
No submission.
Score of General,
/ 20
Graphs, Surveys, and Results
20 points
Graphs, survey links, results or other requirements are included. Graphs and/or surveys are complete and include all details as indicated. Results are correct.
14 points
Graphs, survey links, results or other requirements are included. Graphs and/or surveys are missing a few details. Results may not be correct.
6 points
Graphs, survey links, results or other requirements are included. Graphs and/or surveys are incomplete and with most details omitted. Results are incorrect.
0 points
No submission.
Score of Graphs, Surveys, and Results,
/ 20
Software
10 points
Student shows an understaing of Excel, StatCrunch and /or Google Forms. Software is applied correctly. The graph/survey form is neat, clear and easy to read.
7 points
Student shows limited understanding of Excel, StatCrunch and /or Google Forms. Software may not be applied correctly. The graph/survey form is somewhat difficult to read. 3 points
Student attempts to use Excel, StatCrunch and /or Google Forms with very little understanding of these programs. Software was not applied correctly. Graphs/surveys are messy and not easy to read.
0 points
No submission.
Score of Software,
/ 10
TotalScore of Dropbox Assignment Rubric,
/ 50

It is important for you to be able to read and interpret common statistical tests. For this lab, you will review standard ways of reporting inferential statistics and identify errors in a practice sheet. Please do the following:
1) Review the inferential statistics document.
2) Review the statistics summary document.
3) Complete and submit the Lab 8 exercise sheet.
Use the Following: File stats summaries.pdf stats summaries
File New Lab 8.docx New Lab 8.docx
File T test and ANOVA.docx T test and ANOVA.docx

Use minitab to answer the question use  2 difrenet hypothesis for example 1 Hypothesis Test (Means),Chi-Square Distribution) and  3 different hypothesis test for example 2 (Hypothesis Test (Means),Chi-Square Distribution,F-Distribution)
in the PowerPoint and screenshot the results into a word document and describe the result. 

On the spreadsheets the tan boxes need formulas to fill them in and I need excel charts made for the data on each spreadsheet. 

please see pictures for the questions and the format on how to do this assignment . Below each question explain why you now realize how you got the answer incorrect. Every question on the exam has an explanation on how it should be answered on the final exam discussion board or one of my exam keys provided with most homework assignments. Here is an example of how you need to format this homework
I got the question above wrong. I found the answer by looking at the linear regression exam key. Here is what I found. “First, figure out what the IDVs are or is. Remember IDVs cause changes in the DV. A variable or variables that “predict” another variable would most likely be the IDV or IDVs. Something that is being predicted would be classified as the DV. Now we need to figure out the level of measurement for the IDV/s and DV. Whenever you see the word scale, your variable or variables are quantitative. Whenever you see on “on a scale from 1 to 10” the variable is quantitative. In this example, you have several quantitative IDVs predicting one quantitative DV. The linear regression is the only analysis we learned about that fits this description.”
The two IDVs found on the exam question are described as being measured on a 10 point scale. The professor stated that these variables were to be considered quantitative. Two quantitative variables predicting a quantitative variable means that this analysis should be a linear regression. The second question I got wrong on the exam is below. I found the correct answer for this question by reviewing the final exam discussion board post on Factorial ANOVA. I copied the below from the final exam discussion board. “-A researcher is interested in knowing if type of diet plan and exercise level by group has an impact on weight loss percent. What type of analysis is should the researcher perform.
Twoway ANOVA. I know this because diet plan and exercise level are implied to have an impact on weight loss. The text in bold helps me determine that these are categorical variables.
–A researcher is interested in knowing if type of diet plan (fast, keto, or pesco) and exercise level (intense or low impact) has an impact on weight loss percent. What type of analysis is should the researcher perform?
3 * 2 ANOVA. I know this because the number of groups for each IDV is provided in the word problem!”
I was instructed to give the best answer. The example is almost identical to the exam question. I should have answered 2*3 ANOVA. ++++
You should get the idea. Follow my example for each question you got wrong find the correct answer by looking at the exam discussion board or exam keys provided with the homework. Copy and paste the portion of the final exam discussion board or exam key that helped you find the answer. There will be a link on Canvas to submit your extra credit. You will have to until December 16th to complete your extra credit and increase your final course grade!