Calculate all Descriptive Statistics with Excel sheet attached below

Calculate all Descriptive Statistics with Excel sheet attached below. Calculate all Descriptive Statistics with Excel sheet attached below.

You will submit the Excel sheet with the following information:
Make a Frequency Distribution with 5 classes, also list the midpoints, relative frequency, and cumulative relative frequency
Make a relative frequency ogive Don’t forget descriptive title and labels on x and y axis (ogive is not descriptive, what does the graph represent?)

Make a frequency polygon Don’t forget a descriptive title and labels on x and y axis (polygon is not descriptive, what does the graph represent?)

Calculate the mean
Calculate the median
Calculate the sample standard deviation (our data is sample from our class, not a population!)
Calculate the Q1 and Q3 values
[supanova_question]

This information is from Table 2 on page 1110 of the Nonsedation vs. Light Sedation study. The primary outcome

This information is from Table 2 on page 1110 of the Nonsedation vs. Light Sedation study. The primary outcome of this study was “All-cause mortality 90 days after randomization”. Look at the highlighted (boxed) information and answer these questions. NOTE: Watching the Introduction Video for the Week Three assignments and the Week Three lecture will help you know how to answer these questions.

1. Explain the details for the mathematical calculation that resulted in the value of 5.4 AND explain specifically what the value of 5.4 means. In other words, interpret the value of 5.4 in relation to this specific outcome of the study. Your answer should include these things:

Explain the details of how the value of 5.4 was calculated.
5.4 what?
What does this mean when I compare the two groups? Which group has the best results (This is where you ask the “Which group would I want to be in?” question).
2. What does the CI range of -2.2 to12.2 mean? What is your interpretation of this? Your answer should include these things:

A statement about what this means if the study were repeated 100 times
What this range specifically means relative to this study outcome – what does this range of results mean for this specific result?
A statement about whether the value of no effect/no difference for this CI range is zero or one AND a statement about whether the CI range included this value.
A statement about what the CI range tells you about the p-value (will the p-value for this result be statistically significant?).

This information is copied from Appendix table S2 on page 5 of the supplement titled Supplementary Appendix for the Nonsedation vs. Light Sedation study. Please look at the highlighted (boxed) line of information and answer the following questions:

1. Is the p-value listed statistically significant? Your answer should state “yes” or “no” and then specifically explain why you chose the answer you did.

2. Are the highlighted results clinically significant? Your answer should state “yes” or “no” and then specifically explain why you chose the answer you did.

3. Explain the relationship of the 95% CI of (1.3% to 8.7%) to the p-value (.01). In other words, explain how looking at the CI range can provide you with information about whether the p-value will or will not be statistically significant.

Please answer these questions and explain the answer for each one. Each question specifically explain why you chose the answer you did.

Attached files will help answer as well, the charts needed to answer each questions has been screenshotted and attached.[supanova_question]

Problem Set 6

Calculate all Descriptive Statistics with Excel sheet attached below intro-to-religion-and-contemporary-culture-2/”>Statistics Assignment Help Deliverables
Preliminary Regression: Problem Set 6
To get you started, you should develop a regression that fits the training data well. Paste the Excel regression output in a pdf (with your name, section, and state that you are modeling) that you hand in by MONDAY NOV 8 at 11 pm as an upload on your section’s Questrom Tools Assignments as Problem Set 6. This does not have to be your final best regression for the project. The purpose is to get your started on assignment and working with the data and creating new variables.
This will be graded as a problem set. TAs will give one of 3 grades: 100=regression model with lags and other several other X variables; 80=regression model with combination of several X variables but no lags; or 50=regression with only one X. If you do not turn this in, you will get a 0. After you hand it in, you might want to discuss this model with your professor or TA.
Each of you should use data from one of 4 states, assigned to you according to the last digit of your BU ID. (MY LAST DIGIT is 8)
If the last digit is 0, 1 or 2: Your state is Massachusetts
If the last digit is 3 or 4: Your state is Alabama
If the last digit is 5 or 6: Your state is New Jersey
If the last digit is 7, 8 or 9: Your state is Texas
You should end your training data set on the following date in August 2021, according to the second to the last digit of your BU ID. (MY SECOND LAST DIGIT WAS 2)
If the second to last digit is 0, end your training data on August 10
If the second to last digit is 1, end your training data on August 11
If the second to last digit is 2, end your training data on August 12
[supanova_question]

Statistical Analysis in Psychology (central tendency, variability and descriptive statistics)

Please answer the following question specifically (the document is uploaded)
Let the sample A = {1, 2, 2, 0, 3, -5, 7, 3, 8, 7, 7, 8, 9}. Create a distribution graph. Discuss the measures of central tendency(mean median mode) and skewness

Donations were collected for the sports fund. Mr. Wilson was able to collect 7 donations in the amounts of: $106, $100, $450, $748, 100, $50, $200. Create a distribution graph. Discuss the measures of central tendency (mean median mode) and skewness.

A graduate student in Psychology was asked to grade 40 final exams, selected at random from several large sections of an introductory course. The resulting scores are found below:
84929683628381859174615283738578508137608510079817592807578716465
Find the measures of central tendency (mean median mode). Create a distribution graph. Discuss the data points on the x-axis and y-axis. Discuss the skewness.

An experiment was conducted to compare the mean number of panic attacks per week experienced by individuals that had been treated with immersion therapy at a clinic against the mean number in those that were treated with hypnotherapy. A sample of 60 of the clinic’s patients suffering from panic attacks was randomly selected, and patients were then randomly assigned to one of two treatment groups. Thirty were treated with hypnotherapy and the remaining patients were treated with immersion therapy. After a one-year period, the patients were asked how many panic attacks they had experienced in the past seven days. Is there a difference, on average, in the number of panic attacks experienced per week by the hypnotherapy treated patients and the immersion-therapy treated patients in this study? On the basis of our findings with the patients in this study, can we infer that, on average, the same difference between individuals treated with hypnotherapy and immersion-therapy exists in this patient population? Discuss the findings and present your data in a graph.
Immersion
Therapy
4
8
6
4
9
5
4
8
6
4
9
5
4
8
6
4
9
5
3
2
1
3
7
5
3
2
1
3
7
5
Hypnotherapy
3
2
1
3
7
5
3
2
1
3
7
5
3
2
1
3
7
5
4
8
6
4
9
5
4
8
6
4
9
5
[supanova_question]

https://anyessayhelp.com/ Deliverables
Preliminary Regression: Problem Set 6
To get you started, you should develop a regression that fits the training data well. Paste the Excel regression output in a pdf (with your name, section, and state that you are modeling) that you hand in by MONDAY NOV 8 at 11 pm as an upload on your section’s Questrom Tools Assignments as Problem Set 6. This does not have to be your final best regression for the project. The purpose is to get your started on assignment and working with the data and creating new variables.
This will be graded as a problem set. TAs will give one of 3 grades: 100=regression model with lags and other several other X variables; 80=regression model with combination of several X variables but no lags; or 50=regression with only one X. If you do not turn this in, you will get a 0. After you hand it in, you might want to discuss this model with your professor or TA.
Each of you should use data from one of 4 states, assigned to you according to the last digit of your BU ID. (MY LAST DIGIT is 8)
If the last digit is 0, 1 or 2: Your state is Massachusetts
If the last digit is 3 or 4: Your state is Alabama
If the last digit is 5 or 6: Your state is New Jersey
If the last digit is 7, 8 or 9: Your state is Texas
You should end your training data set on the following date in August 2021, according to the second to the last digit of your BU ID. (MY SECOND LAST DIGIT WAS 2)
If the second to last digit is 0, end your training data on August 10
If the second to last digit is 1, end your training data on August 11
If the second to last digit is 2, end your training data on August 12
[supanova_question]