QNT275 DeVry University Calculating Binomial Probabilities

Statistical Concepts: ProbabilityBinomial Probability Distribution Calculating Binomial Probabilities

NOTE:For question 1, you will be using the same data file your instructor gave you for the Week 2 Lab. Using the data file from your instructor (same one you used for the Week 2 Lab), calculate descriptive statistics for the variable (Coin) where each of the thirty-five students in the sample flipped a coin 10 times. Round your answers to three decimal places and type the mean and the standard deviation in the grey area below.Create scatter plots for the binomial distribution when p=0.50, p=0.25, and p=0.75 (see directions above).Paste the three scatter plots in the grey area below. List the probability value for each possibility in the binomial experiment calculated at the beginning of this lab, which was calculated with the probability of a success being ½. (Complete sentences not necessary; round your answers to three decimal places.) Give the probability for the following based on the calculations in question 3 above, with the probability of a success being ½. (Complete sentences not necessary; round your answers to three decimal places.) Calculate (by hand) the mean and standard deviation for the binomial distribution with the probability of a success being ½ and n = 10. Either show your work or explain how your answer was calculated. Use these formulas to do the hand calculations: Mean = np, Standard Deviation = Calculate (by hand) the mean and standard deviation for the binomial distribution with the probability of a success being ¼ and n = 10. Write a comparison of these statistics to those from question 5 in a short paragraph of several complete sentences. Use these formulas to do the hand calculations: Mean = np, Standard Deviation =

Calculate (by hand) the mean and standard deviation for the binomial distribution with the probability of a success being ¾ and n = 10. Write a comparison of these statistics to those from question 6 in a short paragraph of several complete sentences. Use these formulas to do the hand calculations: Mean = np, Standard Deviation =
Using all four of the properties of a Binomial experiment (see page 201 in the textbook) explain in a short paragraph of several complete sentences why the Coin variable from the class survey represents a binomial distribution from a binomial experiment.Compare the mean and standard deviation for the Coin variable (question 1) with those of the mean and standard deviation for the binomial distribution that was calculated by hand in question 5. Explain how they are related in a short paragraph of several complete sentences. Mean:

Standard deviation:

NOTE:for questions 2-7, you will NOT be using the data file your instructor gave you.Please follow the instructions given in each question.

Plotting the Binomial Probabilities For the next part of the lab, open the Week 3 Excel worksheet.This will be used for the next few questions, rather than the data file used for the first question. Click on the “binomial tables” workbookType in n=10 and p=0.5; this simulates ten flips of a coin where x is counting the number of heads that occur throughout the ten flipsCreate a scatter plot, either directly in this spreadsheet (if you are comfortable with those steps), or by using the Week 1 spreadsheet and copying the data from here onto that sheet (x would be the x variable, and P(X=x) would be the y variable.Repeat steps 2 and 3 with n=10 and p=0.25Repeat steps 2 and 3 with n=10 and p=0.75In the end, you will have three scatter plots for the first question below.

Calculating Descriptive Statistics

Short Answer Writing Assignment – Both the calculated binomial probabilities and the descriptive statistics from the class database will be used to answer the following questions.Round all numeric answers to three decimal places.

P(x=0)

P(x=6)

P(x=1)

P(x=7)

P(x=2)

P(x=8)

P(x=3)

P(x=9)

P(x=4)

P(x=10)

P(x=5)

P(x≥1)

P(x<0)

P(x>1)

P(x≤4)

P(4<x ≤7)

P(x<4 or x≥7) Mean = np:

Standard Deviation = : Mean = np:

Standard Deviation = :

Comparison: Mean = np:

Standard Deviation = :

Comparison:

NOTE:For questions 8-9, you will use the results of the previous questions. Mean from question #1:

Standard deviation from question #1:

Mean from question #5:

Standard deviation from question #5:

Comparison and explanation:

QNT275 Phoenix Week 2 Car Dealership Mean Days in Inventory Project

Part 1: to be completed in Microsoft® Excel®

You manage the inventory for a car dealership. Data on current inventory can be found in the Week 2 Data Set. Management would like you to assess current inventory on the dealership lot.

Using the Week 2 Data Set, create and calculate the following in Microsoft® Excel®:Create a pie chart which summarizes the colors of the cars in the sample.Create a bar chart which summarizes the number of each of the models of cars in the sample.Create a frequency table for classes of MPG, including frequency and relative frequency for the cars in the sample.Calculate the mean Days in Inventory for the cars in the sample. Also, do the following:Compare the mean to the median and the mode. Highlight the value that would be a better representation of the “typical” price of a car in inventory.Calculate the standard deviation of the Days in Inventory for the cars in the sample. Calculate the 5 number summary for the suggested retail prices of the cars in the sample. This consists of the 1st, 2nd, 3rd, 4th quartile, and the IQR.

IBM SPSS Statistics Standard GradPack(The Base GradPack is not acceptable)Histograms and Descriptive

Part 1: Histograms and Descriptive Statistics

Your first IBM SSPS assessment includes two sections: Create two histograms and provide interpretations.Calculate measures of central tendency and dispersion and provide interpretations. Key Details and Instructions Submit your assessment as an attached Word document.Begin your assessment by creating a properly formatted APA title page. Include a reference list at the end of the document if necessary. On page 2, begin Section 1.Organize the narrative report with your SPSS output charts and tables integrated along with your responses to the specific requirements listed for that assessment. (See the Copy/Export Output Instructions in the Resources for instructions on how to do this).Label all tables and graphs in a manner consistent with APA style and formatting guidelines. Citations, if needed, should be included in the text as well as a reference section at the end of the report.For additional help in completing this assessment, refer to the IBM SPSS Step-By-Step Instructions: Histograms and Descriptive Statistics document, linked in the Required Resources. Section 1: Histograms and Visual Interpretation

Section 1 will include one histogram of “total” scores for all the males in the data set, and one histogram of “total” scores for all the females in the data set.

Create two histograms using the totaland gendervariables in your grades.savdata set: A histogram for male students.A histogram for female students.

Below the histograms, provide an interpretation based on your visual inspection. Correctly use all of the following terms in your discussion: Skew.Kurtosis.Outlier.Symmetry.Modality.

Comment on any differences between males and females regarding their total scores. Analyze the strengths and limitations of visually interpreting histograms. Section 2: Calculate and Interpret Measures of Central Tendency and Dispersion

Using the grades.savfile, compute descriptive statistics, including mean, standard deviation, skewness, and kurtosisfor the following variables: id.gender.ethnicity.gpa.quiz3.total.

Below the Descriptives table, complete the following: Indicate which variable(s) are meaningless to interpret in terms of mean, standard deviation, skewness, and kurtosis. Justify your decision.Next, indicate which variable(s) are meaningful to interpret. Justify your decision. For meaningful variables, specify any variables that are in the ideal range for both skewness and kurtosis.Specify any variables that are acceptable but not excellent.Specify any variables that are unacceptable. Explain your decisions.For all meaningful variables, report and interpret the descriptive statistics (mean, standard deviation, skewness, and kurtosis). Part 2: Data Screening

For this part of the assessment, respond to the following questions:

What are the goals of data screening? How can you identify and remedy the following? Errors in data entry.Outliers.Missing data. Part 3: z-Scores, Type I and II Error, Null Hypothesis Testing

This IBM SPSS assessment includes three sections: Generate z-scores for a variable in grades.sav and report/interpret them.Analyze cases of Type I and Type II error.Analyze cases to either reject or not reject a null hypothesis.

The format of this assessment should be narrative with supporting statistical output (table and graphs) integrated into the narrative in the appropriate place (not all at the end of the document). See the Copy/Export Output Instructionsfor instructions on how to do this.

Download the z-Scores, Type I and Type II Error, Null Hypothesis Testing Answer Templatefrom the Required Resources, and use the template to complete the following sections: Section 1: z-Scores in SPSS.Section 2: Case Studies of Type I and Type II Error.Section 3: Case Studies of Null Hypothesis Testing. Reference

George, D., & Mallery, P. (2016). IBM SPSS statistics 23 step by step: A simple guide and reference(14th ed.). New York, NY: Routledge.

For this three-part assessment, you will create and interpret histograms and compute descriptive statistics for given variables; analyze the goals of data screening; and generate z-scores for variables, analyze types of error, and analyze cases to either reject or not reject a null hypothesis. You will use SPSS software and several course files to complete this assessment.

By successfully completing this assignment, you will demonstrate your proficiency in the following areas: Analyze the computation, application, strengths and limitations of various statistical tests.Analyze the strengths and limitations of examining a distribution of scores with a histogram.Analyze the relevant data from the computation, interpretation, and application of z-scores.Analyze real-world application of Type I and Type II errors, and the research decisions that influence the relative risk of each.Analyze the decision-making process of data analysis.Analyze meaningful versus meaningless variables reported in descriptive statistics.Apply the logic of null hypothesis testing to cases.Interpret the results of statistical analyses.Interpret histogram results, including concepts of skew, kurtosis, outliers, symmetry, and modality.Interpret descriptive statistics for meaningful variables.Apply a statistical program’s procedure to data.Apply the appropriate SPSS procedures for creating histograms to generate relevant output.Apply the appropriate SPSS procedure for generating descriptive statistics to generate relevant output.Apply the appropriate SPSS procedures for creating z-scores and descriptive statistics to generate relevant output.Communicate in a manner that is scholarly, professional, and consistent with expectations for members of the identified field of study.Communicate in a manner that is scholarly, professional and consistent with expectations for members of the identified field of study.

IBM SPSS Statistics Standard GradPack. (The Base GradPack is not acceptable for use in this course.) but it must be version 22 or higher. Be sure to use the version that is compatible with your operating system (PC or Mac). Suggested Resources

The resources provided here are optional. You may use other resources of your choice to prepare for this assessment; however, you will need to ensure that they are appropriate, credible, and valid. Resources George, D., & Mallery, P. (2016). IBM SPSS statistics 23 step by step: A simple guide and reference(14th ed.). New York, NY: Routledge. Internet Resources Lane, D. M. (2013). HyperStat online: An introductory statistics textbook and online tutorial for help in statistics courses. Retrieved from http://davidmlane.com/hyperstatStatSoft, Inc. (2013). Electronic statistics textbook. Tulsa, OK: StatSoft. Retrieved from http://www.statsoft.com/textbookSophia. (2014). Retrieved from http://www.sophia.org/Browse Sophia for tutorials that explore statistical topics.StatisticsLectures.com. (2012). Free statistics lectures. Retrieved from http://statisticslectures.com/Khan Academy. (2013). Retrieved from https://www.khanacademy.orgThis Web site offers resources covering a range of subjects, including statisticsHall, R. (1998). Between subjects one-way ANOVA example. Psychology World. Retrieved from http://web.mst.edu/~psyworld/anovaexample.htmElliot, A. C. (2012). ANOVA using Microsoft Excel: One-way analysis of variance. Excel Tutorials for Statistical Data Analysis. Retrieved from http://www.stattutorials.com/EXCEL/EXCEL_ANOVA.htm…Onwuegbuzie, T. (Producer). (2009). Mixed methods research[Video] | Transcript. Available from http://videolectures.net/ssmt09_onwuegbuzie_mmr Preparation

This assessment has three parts, each of which is described below. Submit all three parts as Word documents.

Note:All the course documents you will need for the assignment are attached.

This assessment uses the grades.savfile. The grades.savfile is a sample SPSS data set that is converted from the grades2.datfile. (Use the Data Set Instructionsto convert the grades2.datfile to the grades.savfile that you will use throughout this course.)

The fictional data in the grades.savfile represent a teacher’s recording of student demographics and performance on quizzes and a final exam across three sections of the course. Each section consists of about 35 students (N = 105).

There are 21 variables in grades.sav. To prepare for this assessment, complete the following: Open your grades.sav file and navigate to the “Variable View” tab.Read the Data Set Instructions, and make sure you have the correct Values and Scales of Measurement assigned.

Week 2 Assignment

Case Study: MBA Schools in Asia-Pacific

Purpose of Assignment

The purpose of this assignment is to develop students’ analytical capabilities to evaluate, analyze, and apply descriptive statistics techniques to real-world datasets.

Assignment Steps

Resources: Microsoft Excel®, Case Study: MBA Schools in Asia-Pacific

Review the Case Study: MBA Schools in Asia-Pacific and the Case Study: MBA Schools in Asia-Pacific data set.

Prepare a 1,050-word managerial report for your boss.

Use the following questions for guidelines and directions on what to include in the report:What is the type of data (Quantitative or Qualitative) for each of the columns (variables) in the dataset? If quantitative, is the data discrete or continuous? Neatly summarize your response in a table for all the columns (variables).Using Excel®, find the mean, median, standard deviation, minimum, maximum, and the three quartiles for each of the quantitative variables identified in part 1 above. Neatly summarize in a table on this document. Comment on what you observe.What are the minimum and maximum full-time enrollments? Which schools have the minimum and maximum full-time enrollments?What is the average number of students per faculty member? Is this low or high? What does this mean to prospective applicants who are interested in pursuing an MBA in one of the leading international business schools?What are the mean, median, and modal ages? What does this mean to prospective applicants?What is the mean percentage of foreign students? How many and which schools have 1% and 0% foreign students? Which schools have highest percentage of foreign students? Please state these percentages.What percentage of schools require the GMAT test?What percentage of schools require English tests such as Test of English as a Foreign Language (TOEFL)?What percentage of schools require work experience? From this percentage, does this appear to be a significant factor in gaining admissions?What are the mean and median starting salaries? Which schools have the minimum and maximum starting salaries? How much are these minimum and maximum salaries?What are the mean tuition for foreign students and for local students? Does there appear to be a significant difference? What is the difference between the two means?How many schools require work experience and how many of them don’t? What is the mean starting salary for schools requiring work experience? What is the mean starting salary for schools requiring no work experience?How many schools require English tests and how many don’t? What is the mean starting salary for schools requiring English tests? What is the mean starting salary for schools requiring no English tests?Comment on the skewness for the data on starting salaries:Plot a histogram and determine the skewness.Find the skewness coefficient.Find the mean, median, and mode for starting salaries and compare the three measures to determine skewness.Finally, use Empirical Rule on the starting salaries and determine whether the salaries follow the Empirical Rule.

Format your assignment consistent with APA format.

3 days ago

ATTACHMENTS

qnt561_r9_case_study_mba_schools_in_asia_pacific_grading_guide_week2.doc

qnt561_r9_mba_case_study_week_2.doc

qnt561_r9_mba_case

Week 6 Assignment

About Your Signature Assignment

This signature assignment is designed to align with specific program student learning outcome(s) in your program. Program Student Learning Outcomes are broad statements that describe what students should know and be able to do upon completion of their degree. The signature assignments might be graded with an automated rubric that allows the University to collect data that can be aggregated across a location or college/school and used for program improvements.

Purpose of Assignment

The purpose of this assignment is for students to synthesize the concepts learned throughout the course. This assignment will provide students an opportunity to build critical thinking skills, develop businesses and organizations, and solve problems requiring data by compiling all pertinent information into one report.

Assignment Steps

Resources: Microsoft Excel®, Signature Assignment Databases, Signature Assignment Options, Part 3: Inferential Statistics

Scenario: Upon successful completion of the MBA program, say you work in the analytics department for a consulting company. Your assignment is to analyze the following databases:Consumer Food

Select one of the databases based on the information in the Signature Assignment Options. (which has been selected)

Option 3: Consumer Food

The consumer food database contains five variables: Annual Food Spending per Household, Annual Household Income, Non-Mortgage Household Debt, Geographic Region of the U.S. of the Household, and Household Location. There are 200 entries for each variable in this database representing 200 different households from various regions and locations in the United States. Annual Food Spending per Household, Annual Household Income, and Non-Mortgage Household Debt are all given in dollars. The variable Region tells in which one of four regions the household resides. In this variable, the Northeast is coded as 1, the Midwest is coded 2, the South is coded as 3, and the West is coded as 4. The variable Location is coded as 1 if the household is in a metropolitan area and 2 if the household is outside a metro area. The data in this database were randomly derived and developed based on actual national norms.

Provide a 1,600-word detailed, statistical report including the following:Explain the context of the caseProvide a research foundation for the topicPresent graphsExplain outliersPrepare calculationsConduct hypotheses testsDiscuss inferences you have made from the results

This assignment is broken down into four parts:Part 1 – Preliminary AnalysisPart 2 – Examination of Descriptive StatisticsPart 3 – Examination of Inferential StatisticsPart 4 – Conclusion/Recommendations

Part 1 – Preliminary Analysis (3-4 paragraphs)

Generally, as a statistics consultant, you will be given a problem and data. At times, you may have to gather additional data. For this assignment, assume all the data is already gathered for you.

State the objective:What are the questions you are trying to address?

Describe the population in the study clearly and in sufficient detail:What is the sample?

Discuss the types of data and variables:Are the data quantitative or qualitative?What are levels of measurement for the data?

Part 2 – Descriptive Statistics (3-4 paragraphs)

Examine the given data.

Present the descriptive statistics (mean, median, mode, range, standard deviation, variance, CV, and five-number summary).

Identify any outliers in the data.

Present any graphs or charts you think are appropriate for the data.

Note: Ideally, we want to assess the conditions of normality too. However, for the purpose of this exercise, assume data is drawn from normal populations.

Part 3 – Inferential Statistics (2-3 paragraphs)

Use the Part 3: Inferential Statistics document.Create (formulate) hypothesesRun formal hypothesis testsMake decisions. Your decisions should be stated in non-technical terms.

Hint: A final conclusion saying “reject the null hypothesis” by itself without explanation is basically worthless to those who hired you. Similarly, stating the conclusion is false or rejected is not sufficient.

Part 4 – Conclusion and Recommendations (1-2 paragraphs)

Include the following:What are your conclusions?What do you infer from the statistical analysis?State the interpretations in non-technical terms. What information might lead to a different conclusion?Are there any variables missing?What additional information would be valuable to help draw a more certain conclusion?

Format your assignment consistent with APA format.

Week 5 Assignment

One-Sample Hypothesis Testing Cases

Purpose of Assignment

The purpose of this assignment is to develop students’ abilities to combine the knowledge of descriptive statistics covered in Weeks 1 and 2 and one-sample hypothesis testing to make managerial decisions. In this assignment, students will learn how statistical analysis is used in predicting an election winner in the first case. In the second case, students will conduct a hypothesis test to decide whether or not a shipping plan will be profitable.

Assignment Steps

Resources: Microsoft Excel®, Case Study Scenarios, SpeedX Payment Times

Develop a 700- to 1,050-word statistical analysis based on the Case Study Scenarios and SpeedX Payment Times.

Include answers to the following:

Case 1: Election Results Use 0.10 as the significance level (α).Conduct a one-sample hypothesis test to determine if the networks should announce at 8:01 P.M. the Republican candidate George W. Bush will win the state.

Case 2: SpeedXUse 0.10 and the significance level (α).Conduct a one-sample hypothesis test and determine if you can convince the CFO to conclude the plan will be profitable.

Format your assignment consistent with APA format.

Week 4 Assignment

The Payment Time Case

Purpose of Assignment

The purpose of the assignment is to develop students’ abilities in using datasets to apply the concepts of sampling distributions and confidence intervals to make management decisions.

Assignment Steps

Resources: Microsoft Excel®, The Payment Time Case Study, The Payment Time Case Data Set

Review the Payment Time Case Study and Data Set.

Develop a 700-word report including the following calculations and using the information to determine whether the new billing system has reduced the mean bill payment time:Assuming the standard deviation of the payment times for all payments is 4.2 days, construct a 95% confidence interval estimate to determine whether the new billing system was effective. State the interpretation of 95% confidence interval and state whether or not the billing system was effective.Using the 95% confidence interval, can we be 95% confident that µ ≤ 19.5 days?Using the 99% confidence interval, can we be 99% confident that µ ≤ 19.5 days?If the population mean payment time is 19.5 days, what is the probability of observing a sample mean payment time of 65 invoices less than or equal to 18.1077 days?

Format your assignment consistent with APA format

Statistics Concepts and Descriptive Measures, statistics homework help

Purpose of Assignment

The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel® prior to the course start.

Assignment Steps

This assignment has an Excel® dataset spreadsheet attached. You will be required to only do one of the three datasets

Resource: Microsoft Excel®, Statistics Concepts and Descriptive Measures Data Set

Download the Statistics Concepts and Descriptive Measures Data Set.

Choose one of the following datasets to complete this assignment:Consumer Food ( This is the one I chose)FinancialHospital

Answer each of the following in a total of 90 words:For each column, identify whether the data is qualitative or quantitative.Identify the level of measurement for the data in each column.For each column containing quantitative data:Evaluate the mean and medianInterpret the mean and median in plain non-technical termsUse the Excel =AVERAGE function to find the meanUse the Excel =MEDIAN function to find the medianFor each column containing quantitative data:Evaluate the standard deviation and rangeInterpret the standard deviation and range in plain non-technical termsUse the Excel =STDEV.S function to find the standard deviationFor range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel’s =MIN function

SYM506 Wilmington University Case Study on Business Statistics

perform certain calculations discussed in the assigned reading in order to derive an answer for each problem.use Microsoft Excel to complete each problem and submit a single Excel spreadsheet that contains a separate worksheet (i.e., separate tab) for each problem.have each worksheet be clearly labeled to identify the associated problem.to show all calculations or other work performed to derive your answer(s) for each problem.have your spreadsheet be fully functional (i.e., configured to allow the reader to not only see all numerical values, but also be able to see the underlying formula associated with each calculated value).to label your work in each worksheet to clearly identify the nature of each piece of data or calculated value.

ISS305 Michigan State Dishonesty and Future of Humankind Questions

Please answer each question at least 300 words. Rubric is provided.

Q1: Dishonesty and the Future of Humankind

Do Ariely’s findings about dishonesty make you overall optimistic or pessimistic about human nature and society? On one hand, he finds that people can be tempted to cheat and steal on a small scale pretty easily. On the other hand, he finds that there is often a limit to the extent to which they do so. And yet he also finds that we are even more likely to steal, and to a greater extent, when tempted by something that isn’t cash, which is increasingly the case. And Ariely offers very little advice as to how to curb these propensities. So are we all doomed to endlessly take advantage of one another, or do Ariely’s studies give us reason to hope that we could structure our society in such a way that we’re generally on good behavior? What can you think of that might serve as a solution to our propensities toward dishonesty?

Q2: You’re Now Ariely

Now that you’ve had the opportunity to read about a number of Ariely’s experimental designs, choose one of his studies and think about how it might be conducted differently. That is, take one of Ariely’s ideas about passion, marketing and consumer behavior, social justice and deviance, or irrationality in general, and develop your own experimental design to test the behavioral mechanisms that Ariely seems to find in his respective study. How will you establish a control group and a treatment group? What will the treatment be? How will you measure the behavior of your subjects? How will you know that you have isolated the effects of your treatment and can rule out other potential factors? Would you predict that your findings will match those of Ariely’s study, or might they contradict Ariely’s findings?

Q3: The Power and Perils of Statistics

In your opinion, wherein lies the greatest potential benefit of statistical inference? That is, are the greatest advances and gains to be made within the field of medicine, economics, or some other field? Why this field? Name at least one specific benefit that your chosen field might bring in the near future with the help of statistics, and precisely how statistics can help. Next, wherein lies the greatest danger of the abuse of statistical inference? That is, in what field would such abuse have the worst consequences? (This may be either the same field whose potential advances you’ve already discussed, or a different field.) Again, why this field? Name a specific possible abuse of statistics that you think could lead the field’s research astray in such a way as to have such consequences.

Q4: Programmatic Self-Evaluation

Think about the kinds of program evaluations that would relate to your life, the comparisons that might be made between you as you are now and certain counterfactuals in which one of your characteristics is changed. For example, you are most likely seeking a college degree, but how would certain ‘dependent variables’ – like your life expectancy or your likely wealth at age 65 – be changed if you weren’t? Wheelan touches on this example, so come up with two different characteristics of your own life (ideally, the outcomes of some of the more important decisions that you’ve made in the past, like the decision to seek a degree), and imagine yourself without each of these characteristics (one at a time, of course, so as to isolate the effects of each). Don’t worry about how you would design a test of the effects of each characteristic – each ‘treatment’ – but think about what these effects might be. What might the significant differences be between yourself and each of your two counterfactuals, in terms of things like long-term health, long-term earnings, long-term happiness, etc.? For each of your two comparisons, make two suggestions as to what the ‘treatment effects’ of your two real-life characteristics might be. (You probably won’t be able to be very precise, but that’s okay.)