Category: Statistics

Hello, in this assignment you will be required to a constrained optimization excel file. The instructions and the questions are attached below. Please take your time when completing the assignment to help me achieve the highest score.
To make it simpler for you, I have also attached “Practice” files, which are almost structurally identical to the assignment itself incase you need further guidance.
Please refer to the grading key and the questions to avoid missing any important points as this assignment builds on itself.
I attached everything you will need to complete the assignment, please use the template provided.
Please reach out if you have any questions, thank you.

This is a written response discussion board, so you will type in your response. For this discussion board post, do one of the following: Define mean, median, and mode and then provide an example of when you would use each. Make sure you explain why you would use that measure of central tendency for each example
Explain the difference between variance and standard deviation. Explain why we tend to report standard deviation instead of variance.

This is a big of a lengthy assignment. I’ve attached everything and all my data. On the file that says project you can just read page 1 and focus only of page 3. The questions that need to be done and answered are boxed in the big green box please thoroughly read them and answer them the best you can. And when starting to get the answers for me please me it easy to read and a easy set up. This is a lot of money for this assignment so please do it correctly!

For the following questions respect APA 7th edition for references if applicable.
Normal curve and probability 
1. The average man weighs 170 pounds (with a standard deviation of 7.5). Hockey player Sidney Crosby of the Pittsburgh Penguins, who scored 103 points in the 2008-09 season, led his team to the Stanley Cup and weighs 193 pounds.
How does Sidney Crosby compare to his band?
(Be precise and complete in your answer: Present all your calculations, present its position in words and on a graph, and present all the percentages associated with its position). 
2. In the NHL, the average player weight is 202 pounds (with a standard deviation of 6.4 pounds).
Where does Sidney fit into this group?
(Be precise and complete in your answer: Present all your calculations, present its position in words and on a graph, and present all the percentages associated with its position). 
3. What conclusion can you draw from the previous questions?
Go to the discussion forum and share your findings. We’ll come back to your observations later in the course. 
The sampling distributions 
1. The social skills level of a four-year-old child measured using a standardized scale is 20.9 (standard deviation = 3.2) and is normally distributed. A community health centre hires you to examine the social skills of a group of children with autism. In fact, the centre’s leaders want to know where this group of 15 four-year-old autistic children stands with an average score of 19.5. 
2. All else being equal, what would happen to score z and your conclusion if the group      were instead composed of 50 children?   
Correlation 
1. Determine the meaning (positive or negative) of each graph. Then, rank them in              ascending order (from weak to strong) according to their strength. 
Note: Remember that there are mathematical formulas that allow us to determine the       exact strength of the relationship. We base our judgment here on a cloud of points, in         order to introduce you to the concept of relationship and allow you to understand it. 
a) See document (image of a graph) 
b) See document (image of a graph) 
c) see document (image of a graph)
d) see document (image of a graph) 
2. If you see a graph like this, what will you conclude? 
Does it appear to be a relationship? What happens when people turn 18? 
a) See document for image of question graph. 
3. Does Nutella help concentration in the classroom? To answer this question, we interviewed students in a Grade 8 class. We started the interview by asking them how many times a week they ate Nutella and we proceeded with 20 questions about the material learned during the week. The results are in the table below. 
a)Make a scatter graph for this research question. 
b)Do these two variables appear to be related? If so, how would you describe them? If not, explain what allows you to say there is no relationship. 
c)Calculate the Pearson correlation.
– See document to help complete the question.         

Please look at the example and do it in the right way and send it Microsoft word.
Prompt. I have completed a number of ANOVA tests using the following variables from the GSS – a national random sample done by a reputable research entity. Note: This is the 2012 data, not the same as what we’re using for the DAP! (For more info on the GSS, visit their website: gss.norc.orgLinks to an external site.
https://gss.norc.org/.
Each of the discussions in this area has one main nominal (or ordinal) variable – and the output from a number of tests with different variables. Choose only one of these nominal/ordinal variables: Class, Degree, Happiness, Life. Download and Open this file and find the tests with the nominal/ordinal variable you chose. Please check the uploaded file.
Then Choose ONE of the tests to discuss , so choose one ANOVA test to interpret (your first post) and then discuss (with at least two other posts) those and other findings within that same discussion. In the file, there are two sets of output. The first box of output has the general statistics – the mean, N, and standard deviation. The second box has the test results…
Figure or find the df’s (df between and df within) and, using an alpha of 0.05, find the critical value of the test statistic (- Critical Value of F for ANOVA).
Make a decision about the null hypothesis – accept or reject.
Interpret your findings – is there a relationship between these two variables? If so, what is the nature of that relationship? (Refer to the means or percents) Speculate on why these findings might be as they are.
Here is an example. Please do it correct and send it as a microsoft word.
H1: Social Class and TV hours are related.
H0: Social Class and TV hours are NOT related.
The test statistic: F= 11.841
Critical Value of T= 2.60
df between= 3
df within= 1282
sig=.000
I have to reject the H0 hypothesis there is a relationship.
It’s statistically significant that the lower class watches more TV (4.37). While the upperclass have watched the least amount of TV (2.37). This would imply that the upper class can do more outside activities or do more things with the money they have compared to the lower class not being able to do these actions and instead stay home and watch TV.

I will provide an excel file with the data in it and there are questions on each column. I want demographic factors, descriptive analysis, inferential analysis and interpretation of results from those data using SPSS.

The term paper will
investigate the correlation between self-reported social media usage patterns
and academic performance among university students. The research will collect
data from a randomly selected sample of students using a structured online survey
with questions related to academic performance metrics (GPA) and frequency and
duration of social media use.

please solve the following homework of finding the amount of people doing those professions in spain by region and municipality and the turnover of every profession. and provide the sources. the homework should be filled on the same excel I provided, with the most updated data available.

CONFIDENCE INTERVALS 
For the confidence intervals, you will be using the PANIC process.  You MUST include the following to earn full credit:
P: State the random variable AND the parameter in words, using correct statistical notation
A: Check the assumptions for approximate normality for the sampling distribution of quantitative data
N: The “Test” you are using on your calculator, AND the values you are entering into the calculator for that test.
I: Name the point estimate AND give the confidence interval in interval form
C: State your final conclusion in words in the context of the problem.
Using the PANIC process, construct a 90% confidence interval for the GPA of students who record, on average, LESS than 10,000 steps per day. 
Using the PANIC process, construct a 90% confidence interval for the GPA of students who record, on average, MORE than 10,000 steps per day.  
What do the two confidence intervals tell you about the data? Can you reach any conclusions about a difference between the two groups (those who logged on average less than 10,000 step per day, and those who logged more than 10,000 steps per day) based on the confidence intervals? 
HYPOTHESIS TESTS 
Oral Roberts University has a “Fast Track” program that allows upper-level (junior and senior) students to enroll concurrently in both undergraduate and graduate courses.  Students must have maintained a minimum GPA of 3.00 to be considered for this program.  Even though the students in our sample are only First-year students, we will use a GPA of 3.00 as our benchmark grade.  For our first hypothesis test, we will be testing the claim that students who average less than 10,000 steps per day have an average GPA of more than 3.00.  For our second hypothesis test, we will be testing the claim that students who average more than 10,000 steps per day have an average GPA of more than 3.00.
For the Hypothesis tests, you do NOT have to use the full PHANTOMS process, since you have already completed some of the steps with your confidence interval.  However, you MUST include the following:
H: The null and alternative hypothesis (using correct notation)
N: The “Test” you are using on your calculator, AND the values you are entering into the calculator for that test.
T: The sample statistic and the test statistic (using appropriate statistical notation for each)
O: The p-value (again, using appropriate statistical notation)
M: Whether you reject or fail to reject the null hypothesis
S: Your final conclusion in the context of the problem.
Test the hypothesis that students who record, on average, LESS than 10,000 steps per day will have an average GPA greater than 3.00. Use a 5% level of significance. 
Test the hypothesis that students who record, on average, MORE than 10,000 steps per day will have an average GPA greater than 3.00. Use a 5% level of significance. 
Based on the conclusions of each of the hypothesis tests, can you make any conclusions about the academic achievement of each of these groups?  Clearly explain your reasoning. 
CONCLUSION 
Return to the original article.  Re-read the discussion and the Conclusion on pages 10-11.  Summarize the findings of YOUR statistical analysis of the sample data by answering the following questions.  Be sure to address ALL of the points below, plus anything else you think is relevant to your conclusions.
What connections do you see between the DESCRIPTIVE statistics (your boxplots & histograms) and the INFERENTIAL statistics (your confidence intervals & hypothesis tests). Be specific. 

. A group of 9 executives of a certain firm include 4 who are married, 3 who never married, and 2 who are divorced. Three of the executives are to be selected for promotion. Let X denote the number of married executives and Y the number of never married executives among the 3 selected for promotion. Assuming that the three are randomly selected from the nine available, what is the joint probability density function of the random variables X and Y?