The attached file Professor-Students.xlsx has the initial table created during the analysis.

It shows a list of students and courses. How will you change that into a format that can be read into a database program?

So do our Database Design on both files and submit the results.

Be aware that grade depends on both student and course.

But gpa depends on student only.

Comments from Customer

Customer is an international student. Please, provide a regular grammatically correct, well-structured paper according to the instructions and academic context provided, written with simple sentence structures and easy vocabulary (or shortly, use simple English).

# Category: Statistics

## We need to do the following:

We need to do the following:

Frequency analysis of the demographic questions only

Correlation analysis of the different parts of the questionnaire. To do this:

create 4 new variables (TotalWE; TotalPEP; TotalCHS; TotalTI) for each part. This total is a summation of the questions/answers received on each part

use this total in analyzing the correlation

Regression analysis (use the totals created above) to analyze (all the 5 relationships)

Structured equation Modeling (Model Fit test) of the model

Perceived Performance,Competition to hire the highly skilled,Turnover Intention,Work environment

## Include

Assignment #1 (Descriptive Statistics)

Objectives of Assignment

The student will learn how to:

enter data into SPSS,

run descriptive statistics in SPSS,

report findings of SPSS descriptive analyses in APA format,

create tables and figures showing findings of SPSS descriptive analyses in APA format,

apply correct terminology in reporting findings, and

employ APA formatting for scientific research reports.

Steps of Assignment

1. Work with the two variables from the School Finance Excel spreadsheet assigned to you. [Week 01 and 02 Class dataset]

Enter the data for your assigned variables into SPSS.

2. Run the following descriptive statistics (if appropriate) for each variable: mean, median,

mode, frequency, variance, standard deviation, skewness, and kurtosis. Design a table in

correct APA format to display your results. Title your table appropriately using correct

APA format.

3. Create a histogram for each variable superimposing the normal curve on each. Include

these in your paper in correct APA format including titles.

4. Pick a title for your paper.

5. Interpret the findings that you have put into tables and histograms by writing in text about them using the terms and concepts learned in class. Be sure to include tables and figures

in your paper. You must resize the figures; the original ones will be too large to include

in a paper.

MAKE SURE YOU INCLUDE ALL THE CONCEPTS TAUGHT IN CLASS. KEEP A

CLOSE CHECK WITH YOUR NOTES.

6. You MUST use correct APA format, including a correctly formatted cover sheet and

running head for your work.

7. Your grade will be based on fulfillment of the objectives listed above as well as the

quality of your writing, the inclusiveness of your writing, and the accuracy (correctness)

of your work.

8. This paper may be no longer than eight (8) pages including the title page and references.

9. Include your original output in an appendix. Items in appendixes do not have to be in

APA format. Appendix pages are not considered part of the eight (8) page limit.

APA Reminders

This list is not intended to be all-inclusive. It is only intended to give you an idea of some

points to consider.

Make sure the entirety of each table is on one page. Do not carry part of a table to

another page.

Always insert tables or diagrams immediately after the paragraph where each is first

introduced.

Do not use color.

Always refer to the table or figure by table or figure number.

Remember to use the correct unit of the variables with which you are working.

Hello, there are questions I need the answer to, please, I uploaded the book for this class also most of the solutions for these questions will be found in the (Probability) module

that needs to be improved.

1. Select one of the opportunities for improvement from homework #2. Specify the current process associated with the opportunity and identify at least 10 different wastes (you do not have to specify a waste for all of the nine different categories).

2. Then, complete a VOC Plan associated with the current process, including the main customers, what you need to know from those customers, reactive and proactive sources of information, and your plan to get additional information.

The waste form and VOC template are available.

Part II

From the chosen process opportunity,

1. Create a SIPOC,

2. Create a value stream map or flow chart,

3. Use the problem identification worksheet to arrive at a Problem Statement.

4. publish the Project Charter. Be sure to complete all sections of the charter. You can make up names for roles and team members. Provide reasonable estimate for financial benefit and project timeline.

(Templates for the SIPOC and problem identification are available

I have the homework 2, added. You can use that as a template and feel free to change the organization

Questions to be solved with three equations of equilibrium, IE Moment and Sum of forces in X&Y. Free body diagrams to be displayed with forces & reactions. Live loading included is in KPA.

(This assignment is through my MBA course of Organizational Behavior in Business.)

Verify and correct (if minimal, highlight any corrections) the attached Stephen_Data Analytics Project Data_Stephen file by doing the following:

Using 1.50 instead of 1.96 for the Correlation Interval formula (as done in the attached Project Example with Formulas file), and data from the EMBA Data Analytics Project Data file (different from the data in Project Example file).

The attached jpeg shows the Predictors, Commitment’s (Affective, Normative, and Continuance), and Performance (my Team is focusing on Task). This should already be reflected in the Stephen file that you’re verifying.

Also, please add a worksheet to the Stephen file and complete the following:

1. Add a worksheet to the Stephen file name Multiple Regression and perform the Multiple Regression with the Stephen file as exampled in the Example file.

2. If possible, add another worksheet to the Stephen file and provide ANOVA comparison(s) with chart(s).

Thank you!!

## Simplifying groups and clusters.

Review the following resources in the Wk 2 Learning Activities folder to help you with this assignment:

LinkedIn Learning videos: “Using Statistical Charts” and “Working with Excel Graphics”

The following chapters of The Tao of Statistics: A Path to Understanding (with no Math) from the Wk 2 University Library Readings:

Ch. 6, “Simplifying Groups and Clusters”

Ch. 7, “Counts Frequencies”

Ch. 8, “Pictures Graphs”

Ch. 9, “Scatterings Distributions”

Frequency & Distribution

Keller, D. K. (2006). Simplifying groups and clusters. In The Tao of statistics: A path to understanding (with no math) (pp. 22-25). SAGE Publications, Inc.

Keller, D. K. (2006). Counts frequencies. In The Tao of statistics: A path to understanding (with no math) (pp. 26). SAGE Publications, Inc.

Keller, D. K. (2006). Pictures graphs. In The Tao of statistics: A path to understanding (with no math) (pp. 28-29). SAGE Publications, Inc.

Keller, D. K. (2006). Scatterings distributions. In The Tao of statistics: A path to understanding (with no math) (pp. 30-33). SAGE Publications, Inc.

Use the shared results from the Student Data Table to complete the following problems. Make sure to show all work/calculations.

Calculate the Pearson correlation between hand and foot size for members of this STA-201 class. Graph the relationship, determine a hypothesis to test this relationship, and statistically test this hypothesis using alpha=0.05. Interpret all results in a paragraph citing the appropriate statistics.

Calculate the simple linear regression to determine if the amount of sleep (y) can be predicted by time spent on homework (x). Graph the relationship and determine, numerically, if there are any outliers. Interpret all results in a paragraph citing the appropriate statistics.

Hey these assignments I have are supposed to be done on JMP, so I converted the data to Excel. Please use Excel and document the formulas and steps as best you can because those are going to have to be re-entered by me in a JMP import of your final work. I am sending two versions of the JMP 2 Excel conversion because I want to make sure at least one of them works well for you. Be sure to note the “.xls” (recommended, I think) and the “.xlsx”. I should clarify the problems/questions to answer are within the Word .docx. Don’t hesitate to question me on anything unclear, as I need a detailed walkthrough for my own understanding. I need to interpret and record your results into JMP. I need time to do that, so if you could complete the project sooner than the deadline, I will very much appreciate that, and come back to you.