Description
complete excel spread sheet for me from I need to turn it in with the homework you helped me with last week. Thanks for helping me out. I need this by tommorow if possible .
Unformatted Attachment Preview
Table: Invoice Experiment Error
Customer Size
+
+
+
+
Customer Location
+
+
+
+
Product Type
+
+
+
+
Number of Errors
12
11
6
2
18
24
16
20
Customer Size: Small (-), Large (+)
Customer Location: Foreign (-), Domestic (+)
Product Type: Commodity (-), Specialty (+)
Customer Size effect
1.25
Customer Location effect
5.25
Product Type
11.75
Size x Location
Effect
average errors (large)
14.25
average errors (small)
13
average errors (Foreign)
16.25
average errors (domestic)
11
average error (Commodity) average error (specialty)
7.75
19.5
+
+
+
+
1.25
Interactions
Size x Product
Effect
+
+
+
+
3.75
Product x Location
Effect
+
+
+
+
2.25
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Hey, so this just involved putting in the new numbers of invoice errors. If you want, you can do a cancellation, since it almost involves no work. Also, do I need to update th...
Completion Status:
100%
Review
Review
Anonymous
Just what I needed. Studypool is a lifesaver!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
12 pages
Ncu Tim7101 Interpret Statistical Output
The video game dataset provided comprises columns labeled, Date, Visits, VisitTime, TotalTime, Game, and Advertising. The ...
Ncu Tim7101 Interpret Statistical Output
The video game dataset provided comprises columns labeled, Date, Visits, VisitTime, TotalTime, Game, and Advertising. The two main variables to be ...
2 pages
Equation
Instructions: Using the knowledge from the Module 02 live lectures, answer the following questions and show ALL work for f ...
Equation
Instructions: Using the knowledge from the Module 02 live lectures, answer the following questions and show ALL work for full credit. You must also ...
RSCH 8210 WU Dataset Used for Quantitative Reasoning Afrobarometer Analysis
In this week’s Discussion, you determined the benefits of visually displaying your data. You also learned that different ...
RSCH 8210 WU Dataset Used for Quantitative Reasoning Afrobarometer Analysis
In this week’s Discussion, you determined the benefits of visually displaying your data. You also learned that different types of data require different visual displays to adequately “tell the story” of the phenomena. Although the Discussion was difficult, what is even more difficult and challenging will be deciding on how best to display the data for presentation purposes. As you move further along in your dissertation or doctoral study, you will find that displaying data will be critical component in presenting a robust and clear capstone project.
For this Introduction to Quantitative Analysis Assignment, you will explore how to visually display data for optimal use.
To prepare for this Assignment:
Review this week’s Learning Resources and consider visual displays of data.
For additional support, review the Skill Builder: Unit of Analysis and the Skill Builder: Levels of Measurement, which you can find by navigating back to your Blackboard Course Home Page. From there, locate the Skill Builder link in the left navigation pane.
Using the SPSS software, open the Afrobarometer dataset or the High School Longitudinal Study dataset (whichever you choose) found in this week’s Learning Resources.
From the dataset you chose, choose one categorical and one continuous variable and perform the appropriate visual display for each variable.
Once you visually display each variable, review Chapter 11 of the Wagner text to understand how to copy and paste your output into your Word document.
For this Assignment:
Write a 2- to 3-paragraph analysis of your results and include a copy and paste of the appropriate visual display of the data into your document.
Based on the results of your data, provide a brief explanation of what the implications for social change might be. Early in your Assignment, when you relate which dataset you analyzed, please include the mean of the following variables. If you are using the Afrobarometer Dataset, report the mean of Q1 (Age). If you are using the HS Long Survey Dataset, report the mean of X1SES.
Testing for Bivariate Categorical Analysis
For this Assignment: Write a 1- to 2-paragraph analysis of your categorical data results for each research scenario. In y ...
Testing for Bivariate Categorical Analysis
For this Assignment: Write a 1- to 2-paragraph analysis of your categorical data results for each research scenario. In your analysis, display the data for the output. Based on your results, provide an explanation of what the implications of social change might be. Use proper APA format, citations, and referencing for your analysis, research question, and display o The paragraphs must answer the questions below: What is the relationship between (state the IV) and (state the DV) Write the null hypothesis Use this format: There is no relationship between (State the IV) and (state the DV) State the research design
Statistics Final Assignment
Final Project
Submit Assignment
Due
...
Statistics Final Assignment
Final Project
Submit Assignment
Due
Saturday by
11:59pm
Points
100
Submitting
a file upload
Available
Jan 7 at 12am - Feb 26 at 11:59pm
about 2 months
The purpose of this assignment is to provide an opportunity to apply the concepts in a real life situation and in the process, develop analytic and practical skills. The data for this project is available here: FinalProjectDataFirmSize.xlsxThe data are from the US Small Business Administration yearly report from 2007. The first column shows ranges of firm size for the different categories (firm size refers to the number of people employed by a given firm). For each firm size range, you will find the number of firms that fit within that range as well as the total number of people employed in that range. For example, in the 5-9 employees range, there are a total of 1,060,250 firms and 6,974,591 employees divided among those firms. Column E has the average annual wages for an employee of that firm size. So for the firms with 5-9 employees, on average, an employee earns $31,889.98 annually in wages. Column F shows the amount of revenue received by the firms in the given size. Continuing with our example, in the 5-9 employee category each firm made on average $1,079,870. Column G shows the revenues a company makes per employee they have. For the firms with 5-9 employees, each employee brought in about $164,157.33 in revenue for the firm. Column H shows the total amount a firm spent on wages to employees. For a firm with 5-9 employees, the firm would spend a total of $63,401.86 per year on wages to employees.You must find the midpoint of the firm size range shown in Column A. Do this by finding the average between the minimum and maximum of the range. For the final category (5,000 and up), use 20,000 as the midpoint. Parts of this project can be completed earlier in the course as the topics are covered. Doing the part that relates to the current material as it is covered will help you keep the project on track instead of having a large volume of work to do at the very end.A successful report should contain the following elements:
Visual representations of the data. You may choose which of the chart types covered in the class to use (Scatter, histogram, pie chart, etc). You may choose to do it all in one chart or use multiple charts. Be sure to label your charts well. If you would like to use a different type of chart from one presented in class, you should first have it approved by the instructor.
Determine the correlation between each of the pertinent data labels and justify why this correlation should be calculated and interpret the correlation you found. You can show correlation visually as well, but you must include the numerical calculations. Since Column F (Mean Pay Per Employee) is calculated from Column D (Total Employment) and Column E (Total Annual Payroll), you should not find the correlation between Columns F and D or E. Likewise, the correlation between Columns A and B would not be useful information as well as finding the correlation between column H and either column C or G.
Find an equation for the regression line for the pairs of variables that have a significant relationship from part 2. You must calculate at least 1 regression line but may choose to do more. Interpret your results. Be careful when determining which variable is the dependent one and include a justification for your choice. You may choose to include a visual representation of the data along with the regression line found.
Use the regression line(s) found in 3 to predict values not included in your independent variable sample but that are within the predictive range of the data. Interpret these values. You must have at least 1 prediction for each regression line.
Perform a hypothesis test for the correlation between two of the variables in at least one of the regressions you chose to include in the paper. Be sure to include both the null and the alternative hypothesis, the test being performed and why, the relative test statistic, and the conclusion you can draw from the test. See page 478 in the textbook for step by step directions.
At least one Bible reference that pertains to the subject as well as 2 quality reference articles. The Biblical reference does not have to be a specific verse or passage per say, but include how the topic relates to Biblical principles and ideals. You can relate the Biblical content to statistics in general or to the topic of wages. The outside references should be from reliable sources who have looked into the relationship between your chosen variables of interest. For example, if you chose to focus on the impact of firm size on one of the other variables, you might look for articles on how the size of a company impacts that other variable.
The components outlined above will be integrated into a comprehensive final report paper, similar to a case study but with more information. This report should be APA formatted, a minimum of 5 pages in length, exclusive of appendices, table of contents, references, and cover sheet.This paper will be graded based on the analysis and summary, as well as the overall clarity and effectiveness of the work. See page 19 of the syllabus for a grading rubric.Rubric
Final Project Rubric
Final Project Rubric
Criteria
Ratings
Pts
This criterion is linked to a Learning Outcome
Content: Identification and evaluation of issues
70.0
pts
Exemplary: You demonstrate clear critical thinking of the case and correctly apply principles in your solutions.
63.0
pts
Accomplished: You demonstrate a competent level of critical thinking of the case and correctly apply principles in your solutions.
55.0
pts
Developing: You demonstrate a limited amount of critical thinking of the case and apply some principles in your solutions
45.0
pts
Beginning: You demonstrate little to no critical thinking of the case and fail to apply principles in your solutions
70.0 pts
This criterion is linked to a Learning Outcome
Ethical / Biblical principles – Recognition of appropriate application of ethical / biblical principles
10.0
pts
Exemplary: Well integrated and relevant to the issues identified
7.0
pts
Accomplished: Strong attempt at integration and relevance
5.0
pts
Developing: Limited applicability / relevance
3.0
pts
Beginning: Little to no integrating / relevance
10.0 pts
This criterion is linked to a Learning Outcome
Structure & mechanics – Grammar and spelling, length, APA
20.0
pts
Exemplary: No grammar or spelling errors. All citations are correct. Length matches the required pages.
16.0
pts
Accomplished: Only a few grammar or spelling errors. Citations are correct. Length is less than the required pages.
13.0
pts
Developing: 3-5 spelling or grammar errors. Some citation errors. Length is less than the required pages.
9.0
pts
Beginning: More than 5 spelling or grammar errors. Multiple citation errors. Length is < required pages.
20.0 pts
Total Points:
100.0
Previous
Next
Similar Content
Linear Algebra Question
use the cross product to find a vector that is orthogonal to both u and v u= (-6,4,2) v= (3,1,5)...
California Southern University Statistics Case Study
I'm working on a statistics case study and need an explanation and answer to help me learn.I have a case analysis and need...
How do you answer this?
Response 1:There are two big difference between z and t confidence intervals. One main difference between the confidence i...
What Position Is Eva In Line? Mathematics Calculation Help
Josie is third in last me I. The lunch room. Her friend Eva is 2 children behind Josie. What position is Eva in line!...
North Carolina A & T State University Behavioral Statistics Worksheet
Homework Assignment #9
20 points
See Syllabus for due date
Chapter 17
Behavioral Statistics (PSYC 212-003)
Ent – Fall 20...
Which sets of numbers are closed under multiplication
Which sets of numbers are closed under multiplication? Choose all answers that are correct. ...
Employee Position Results.edited
I want to know whether there is a statistically significant difference in employee salaries based I will use a pie chart t...
Are All Good Samples Random
"While simple random sampling is known to be an effective way of choosing a sample that is representative to the target po...
Img 902247571359 1
...
Related Tags
Book Guides
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
12 pages
Ncu Tim7101 Interpret Statistical Output
The video game dataset provided comprises columns labeled, Date, Visits, VisitTime, TotalTime, Game, and Advertising. The ...
Ncu Tim7101 Interpret Statistical Output
The video game dataset provided comprises columns labeled, Date, Visits, VisitTime, TotalTime, Game, and Advertising. The two main variables to be ...
2 pages
Equation
Instructions: Using the knowledge from the Module 02 live lectures, answer the following questions and show ALL work for f ...
Equation
Instructions: Using the knowledge from the Module 02 live lectures, answer the following questions and show ALL work for full credit. You must also ...
RSCH 8210 WU Dataset Used for Quantitative Reasoning Afrobarometer Analysis
In this week’s Discussion, you determined the benefits of visually displaying your data. You also learned that different ...
RSCH 8210 WU Dataset Used for Quantitative Reasoning Afrobarometer Analysis
In this week’s Discussion, you determined the benefits of visually displaying your data. You also learned that different types of data require different visual displays to adequately “tell the story” of the phenomena. Although the Discussion was difficult, what is even more difficult and challenging will be deciding on how best to display the data for presentation purposes. As you move further along in your dissertation or doctoral study, you will find that displaying data will be critical component in presenting a robust and clear capstone project.
For this Introduction to Quantitative Analysis Assignment, you will explore how to visually display data for optimal use.
To prepare for this Assignment:
Review this week’s Learning Resources and consider visual displays of data.
For additional support, review the Skill Builder: Unit of Analysis and the Skill Builder: Levels of Measurement, which you can find by navigating back to your Blackboard Course Home Page. From there, locate the Skill Builder link in the left navigation pane.
Using the SPSS software, open the Afrobarometer dataset or the High School Longitudinal Study dataset (whichever you choose) found in this week’s Learning Resources.
From the dataset you chose, choose one categorical and one continuous variable and perform the appropriate visual display for each variable.
Once you visually display each variable, review Chapter 11 of the Wagner text to understand how to copy and paste your output into your Word document.
For this Assignment:
Write a 2- to 3-paragraph analysis of your results and include a copy and paste of the appropriate visual display of the data into your document.
Based on the results of your data, provide a brief explanation of what the implications for social change might be. Early in your Assignment, when you relate which dataset you analyzed, please include the mean of the following variables. If you are using the Afrobarometer Dataset, report the mean of Q1 (Age). If you are using the HS Long Survey Dataset, report the mean of X1SES.
Testing for Bivariate Categorical Analysis
For this Assignment: Write a 1- to 2-paragraph analysis of your categorical data results for each research scenario. In y ...
Testing for Bivariate Categorical Analysis
For this Assignment: Write a 1- to 2-paragraph analysis of your categorical data results for each research scenario. In your analysis, display the data for the output. Based on your results, provide an explanation of what the implications of social change might be. Use proper APA format, citations, and referencing for your analysis, research question, and display o The paragraphs must answer the questions below: What is the relationship between (state the IV) and (state the DV) Write the null hypothesis Use this format: There is no relationship between (State the IV) and (state the DV) State the research design
Statistics Final Assignment
Final Project
Submit Assignment
Due
...
Statistics Final Assignment
Final Project
Submit Assignment
Due
Saturday by
11:59pm
Points
100
Submitting
a file upload
Available
Jan 7 at 12am - Feb 26 at 11:59pm
about 2 months
The purpose of this assignment is to provide an opportunity to apply the concepts in a real life situation and in the process, develop analytic and practical skills. The data for this project is available here: FinalProjectDataFirmSize.xlsxThe data are from the US Small Business Administration yearly report from 2007. The first column shows ranges of firm size for the different categories (firm size refers to the number of people employed by a given firm). For each firm size range, you will find the number of firms that fit within that range as well as the total number of people employed in that range. For example, in the 5-9 employees range, there are a total of 1,060,250 firms and 6,974,591 employees divided among those firms. Column E has the average annual wages for an employee of that firm size. So for the firms with 5-9 employees, on average, an employee earns $31,889.98 annually in wages. Column F shows the amount of revenue received by the firms in the given size. Continuing with our example, in the 5-9 employee category each firm made on average $1,079,870. Column G shows the revenues a company makes per employee they have. For the firms with 5-9 employees, each employee brought in about $164,157.33 in revenue for the firm. Column H shows the total amount a firm spent on wages to employees. For a firm with 5-9 employees, the firm would spend a total of $63,401.86 per year on wages to employees.You must find the midpoint of the firm size range shown in Column A. Do this by finding the average between the minimum and maximum of the range. For the final category (5,000 and up), use 20,000 as the midpoint. Parts of this project can be completed earlier in the course as the topics are covered. Doing the part that relates to the current material as it is covered will help you keep the project on track instead of having a large volume of work to do at the very end.A successful report should contain the following elements:
Visual representations of the data. You may choose which of the chart types covered in the class to use (Scatter, histogram, pie chart, etc). You may choose to do it all in one chart or use multiple charts. Be sure to label your charts well. If you would like to use a different type of chart from one presented in class, you should first have it approved by the instructor.
Determine the correlation between each of the pertinent data labels and justify why this correlation should be calculated and interpret the correlation you found. You can show correlation visually as well, but you must include the numerical calculations. Since Column F (Mean Pay Per Employee) is calculated from Column D (Total Employment) and Column E (Total Annual Payroll), you should not find the correlation between Columns F and D or E. Likewise, the correlation between Columns A and B would not be useful information as well as finding the correlation between column H and either column C or G.
Find an equation for the regression line for the pairs of variables that have a significant relationship from part 2. You must calculate at least 1 regression line but may choose to do more. Interpret your results. Be careful when determining which variable is the dependent one and include a justification for your choice. You may choose to include a visual representation of the data along with the regression line found.
Use the regression line(s) found in 3 to predict values not included in your independent variable sample but that are within the predictive range of the data. Interpret these values. You must have at least 1 prediction for each regression line.
Perform a hypothesis test for the correlation between two of the variables in at least one of the regressions you chose to include in the paper. Be sure to include both the null and the alternative hypothesis, the test being performed and why, the relative test statistic, and the conclusion you can draw from the test. See page 478 in the textbook for step by step directions.
At least one Bible reference that pertains to the subject as well as 2 quality reference articles. The Biblical reference does not have to be a specific verse or passage per say, but include how the topic relates to Biblical principles and ideals. You can relate the Biblical content to statistics in general or to the topic of wages. The outside references should be from reliable sources who have looked into the relationship between your chosen variables of interest. For example, if you chose to focus on the impact of firm size on one of the other variables, you might look for articles on how the size of a company impacts that other variable.
The components outlined above will be integrated into a comprehensive final report paper, similar to a case study but with more information. This report should be APA formatted, a minimum of 5 pages in length, exclusive of appendices, table of contents, references, and cover sheet.This paper will be graded based on the analysis and summary, as well as the overall clarity and effectiveness of the work. See page 19 of the syllabus for a grading rubric.Rubric
Final Project Rubric
Final Project Rubric
Criteria
Ratings
Pts
This criterion is linked to a Learning Outcome
Content: Identification and evaluation of issues
70.0
pts
Exemplary: You demonstrate clear critical thinking of the case and correctly apply principles in your solutions.
63.0
pts
Accomplished: You demonstrate a competent level of critical thinking of the case and correctly apply principles in your solutions.
55.0
pts
Developing: You demonstrate a limited amount of critical thinking of the case and apply some principles in your solutions
45.0
pts
Beginning: You demonstrate little to no critical thinking of the case and fail to apply principles in your solutions
70.0 pts
This criterion is linked to a Learning Outcome
Ethical / Biblical principles – Recognition of appropriate application of ethical / biblical principles
10.0
pts
Exemplary: Well integrated and relevant to the issues identified
7.0
pts
Accomplished: Strong attempt at integration and relevance
5.0
pts
Developing: Limited applicability / relevance
3.0
pts
Beginning: Little to no integrating / relevance
10.0 pts
This criterion is linked to a Learning Outcome
Structure & mechanics – Grammar and spelling, length, APA
20.0
pts
Exemplary: No grammar or spelling errors. All citations are correct. Length matches the required pages.
16.0
pts
Accomplished: Only a few grammar or spelling errors. Citations are correct. Length is less than the required pages.
13.0
pts
Developing: 3-5 spelling or grammar errors. Some citation errors. Length is less than the required pages.
9.0
pts
Beginning: More than 5 spelling or grammar errors. Multiple citation errors. Length is < required pages.
20.0 pts
Total Points:
100.0
Previous
Next
Earn money selling
your Study Documents