Hello, in this assignment you will be required to a constrained optimization exc

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.

Please look at the example and do it in the right way and send it Microsoft word

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.

This is a written response discussion board, so you will type in your response.

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.

. A group of 9 executives of a certain firm include 4 who are married, 3 who nev

. 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?

Use statistical software to create, interpret, and analyze two histograms in a W

Use statistical software to create, interpret, and analyze two histograms in a Word document.
Collapse All
Introduction
Exploring the associations between some variables in the courseroom using correlations might provide some important information about learner success. You’ll need to pay attention to both magnitude, which is the strength of the association, and directionality, which is the direction (positive or negative) of the association. During this assessment, you’ll start learning about how to best approach correlational analyses like these and start getting some answers. You’ll explore the relationships that may or may not exist in your courseroom data.
In this assessment, you’ll get a chance to run and interpret your first inferential statistics analysis: correlations. Your readings and the Course Study Guide will help you in your efforts.
Instructions
For this assessment, you will use the Data Analysis and Application template (DAA Template [DOCX] Download DAA Template [DOCX]).
• For help with statistical software, refer to the JASP Step-by-Step: Correlations [PDF] Download JASP Step-by-Step: Correlations [PDF]document.
• View JASP Speedrun: Correlations [Video] for a brief tutorial video on this assessment.
• Refer to the 7864 Course Study Guide [PDF] Download 7864 Course Study Guide [PDF]for information on analyses and interpretation.
• For information on the data set, refer to the 7864 Data Set Instructions [PDF] Download 7864 Data Set Instructions [PDF]document.
The grades.jasp Download grades.jaspfile is a sample data set. The data represent a teacher’s recording of student demographics and performance on quizzes and a final exam across three sections of the course.
This assessment is on correlations. You will analyze the following variables in the grades.jasp Download grades.jaspdata set:
Variables and Definitions
Variable Definition
Quiz 1 Quiz 1: number of correct answers
GPA Previous grade point average
Total Total number of points earned in class
Final Final exam: number of correct answers
The DAA Template [DOCX] Download DAA Template [DOCX]has five sections:
• Data Analysis Plan.
• Testing Assumptions.
• Results & Interpretation.
• Statistical Conclusions.
• Application.
Step 1: Write Section 1 of the DAA: Data Analysis Plan
• Name the four variables used in this analysis and whether they are categorical or continuous.
• State a research question, null hypothesis, and alternate hypothesis for the total-final correlation.
• State a research question, null hypothesis, and alternate hypothesis for the gpa-quiz1 correlation.
Step 2: Write Section 2 of the DAA: Testing Assumptions
Test for one of the assumptions of correlation—normality.
• Create a descriiptive statistics table in the statistical software to assess normality. This table should include the four variables named above including skew and kurtosis for each variable.
• Paste the table in the DAA template.
• Interpret the skewness and kurtosis values and determine whether the assumption of normality was violated or not violated.
Step 3: Write Section 3 of the DAA: Results & Interpretation
• Using the statistical software, paste the intercorrelation matrix for the four variables into the document.
• Below the output, first report the total-final correlation including degrees of freedom, correlation coefficient, and p value. Specify whether or not to reject the null hypothesis for this correlation.
• Second, report the gpa-quiz1 correlation including degrees of freedom, correlation coefficient, and p value. Specify whether or not to reject the null hypothesis for this correlation.
Step 4: Write Section 4 of the DAA: Statistical Conclusions
• Provide a brief summary of your analysis and the conclusions drawn about correlations.
• Analyze the limitations of the statistical test and/or possible alternative explanations for your results.
Step 5: Write Section 5 of the DAA: Application
• Analyze how you might use correlations in your field of study.
• Name two variables that would work for such an analysis and why studying the relationship may be important to the field or practice.
Submit your completed DAA Template as an attached Word document in the assessment area.
Software
The following statistical analysis software is required to complete your assessments in this course:
• Jeffreys’s Amazing Statistics Program (JASP).
Refer to the Tools and Software: JASP page on Campus for general information. Make sure that your statistical software is downloaded, installed, and running properly on your computer.
Competencies Measured
By successfully completing this assessment, you will demonstrate your proficiency in the course competencies through the following assessment scoring guide criteria:
• Competency 1: Analyze the computation, application, strengths, and limitations of various statistical tests.
o Analyze statistical assumptions.
• Competency 2: Analyze the decision making process of data analysis.
o Articulate the data analysis plan.
• Competency 3: Apply knowledge of hypothesis testing.
o Interpret statistical results and hypotheses.
• Competency 4: Interpret the results of statistical analyses.
o Explain statistical conclusions, the limitations of the test, and/or possible alternative explanations.
• Competency 6: Apply the results of statistical analyses (your own or others) to your field of interest or career.
o Analyze the potential applications of the test in the field and their implications.
• Competency 7: Communicate in a manner that is scholarly, professional, and consistent with the expectations for members in the identified field of study.
o Communicate in a manner that is scholarly and professional, and adheres to APA style and formatting.

Part 1 A principal wants to determine if a new ACT preparation program is effect

Part 1
A principal wants to determine if a new ACT preparation program is effective. The data are contained in the schools.sav data file. Open the schools.sav file in SPSS. Use SPSS to determine whether a significant improvement existed between student performance on ACT tests in 1993 (act93) and ACT tests in 1994 (act94). Assume that the same students were involved in 1993 and 1994 testing. This requires a t-test. Review Chapter 10 of Using SPSS for Windows and Macintosh for information on paired t-tests as well as reporting, interpreting, and writing results using the APA format.
Create a report that answers the principal’s question. Write these conclusions in the APA format. Include your SPSS output to support your conclusion.
Part 2
A pharmaceutical company wants to determine whether there is a need for a new medication based on the data in the electric.sav file. Specifically, they want to determine whether a person is alive or dead 10 years after a coronary incident and whether that is reflected in a significant difference in the patients’ cholesterol levels (chol58) that were taken when the event occurred. Use chol58 as a dependent variable and VITAL10 as your independent variable. Address the following:
Analyze these conditions to determine whether there is a significant difference between the cholesterol levels (vital10) of those who are alive 10 years later compared to those who died within 10 years.
Include the SPSS output, which validates your conclusion.
Write a brief paragraph that describes your conclusions.
Refer to Unit 6 of Using SPSS for Windows and Macintosh for specific information about SPSS tests as well as interpreting and writing APA results. Pay attention to Levene’s test throughout to determine whether the assumption of equal variance was met when you make your final decisions about the analysis.
What conclusion did you reach? Write these conclusions in the APA format. Include your SPSS output to support that conclusion.
Part 3
Occasionally, you have 1 independent variable that has 3 or more levels or groups. For a parametric data set, an analysis of variance (ANOVA) is the proper calculation. Use ANOVA to address the following scenario:
A financial planner is interested in understanding the relationship between the dependent variable of the income level of respondents (rincdol) and the independent variable of their education level (ndegree) from the gss.sav data file. Use SPSS to complete the following:
Run an ANOVA to determine the overall conclusion.
Use the Bonferroni correction as a post-hoc analysis to determine the relationship of specific degree levels to income.
Explain the overall conclusions based on the analysis, and describe the relationship(s) between the levels of the degree earned and income.
Write your conclusion on the findings based upon the output using proper APA formatting.
Submit both the SPSS output file and your Word summary. Refer to Using SPSS for Windows and Macintosh’s section about a one-way ANOVA for information on how to interpret and write APA results.