Statistics homework help

/in /by

Homework Set 11: The following set of problems either taken from lecture notes or from the book: “SIMIO
and Simulation: Modeling, Analysis and Application”, by Smith, Sturrock and Kelton, Kenneth N., 4th ed.
2017. Answer the questions below in MS Excel and SIMIO. Upload your MS Excel Workbooks (*.xlsx
extension) and SIMIO Project Files (*.spfx extension) in Blackboard.
Homework 1: HW_7_06 in the book
a) Develop the simulation model where staff scheduled patient arrivals once every 10 minutes.
Develop an experiment with response variables evaluating the number of patients seen, the average
waiting time of patients and the total time the doctor has to stay. This problem is worth 2 points
in terms of Effort.
b) Add a schedule to the patient arrival table in the simulation “HW_7_06.spfx” where (i) 2 patients are
scheduled every 20 minutes, (ii) another schedule where 3 patients are scheduled every 20 minutes
and (iii) another schedule where 1 patient is scheduled every 9 minutes. Add a reference property
“ArrivalTimeProperty” to the experiment and run 4 scenarios, the first one using the schedule
under question (a) and the other three scenarios using the three scheduling methods (i), (ii) and
(iii) above. Run the Experiment for 500 Replications. This problem is worth 2 point in terms of
Effort.
c) What are your conclusions based on the analysis result under b? This problem is worth 1
point in terms of Effort.
Homework 2: HW_7_07 in the book
a) Download the simulation “Model 7_2.spfx” and add a “Severe_to_Urgent” Patient to the “PatienData”
Table. Save the file as “HW_7_07.spfx”. Add a “Real” Column called “HW_7_07_MIX” and set the
percentages to the percentages provided in Homework 7-07 from the book. Add to the Sequence
Column the info for “Severe_To_Urgent” patients in the “Treatment_Table” while setting the
treatment time distributions of the “Severe_To_Urgent” patients in the Trauma and Treatment
Rooms equal to those of the “Urgent” patients. This problem is worth 1 points in terms of Effort.
b) Add reference property “Patient_Mix” to the Experiment of “Homewor_7_07.spfx” and add a
Scenario to the experiment called “HW_7_07_Mix”, change the Patient Mix to that of HW_7_07. Add a
Response Variable for the W (Time in System) and the Througput (Number of Patients server per
hour) and rerun the experiment for 100 replications. Save the simulation model as “HW_7_07.spfx”.
This problem is worth 1 point in terms of Effort.
c) Copy the workbook “Steady State Calculation Model 7_2.xlsx” and name it workbook “Steady State
Calculation HW 7_07.xlsx . In this new workbook copy the worksheet “Model 7-2” and rename this
sheet “HW_7_07”. Modify the worksheet HW_7_07 by setting the patient mix percentages to the
percentages in HW_7_07 at each of the servers “SIGNIN”, “REGISTRATION”, ‘EXAM ROOM”,
TRAUMA ROOM” and “TREATMENT ROOM and re-evaluate the Steady State Results for their
utilizations. This problem is worth 1 point in terms of Effort.
d) Compare the steady results for the new patient mix in the worksheet “HW_7_07” to the scenario
results in SIMIO using SMORE plots and also compare the results using the HW_7_07 patient mix to
the original patient mix of Model 7-2. What are your conclusions? This problem is worth 1
point in terms of Effort.

Statistics homework help

/in /by

Homework Set 11: The following set of problems either taken from lecture notes or from the book: “SIMIO
and Simulation: Modeling, Analysis and Application”, by Smith, Sturrock and Kelton, Kenneth N., 4th ed.
2017. Answer the questions below in MS Excel and SIMIO. Upload your MS Excel Workbooks (*.xlsx
extension) and SIMIO Project Files (*.spfx extension) in Blackboard.
Homework 1: HW_7_06 in the book
a) Develop the simulation model where staff scheduled patient arrivals once every 10 minutes.
Develop an experiment with response variables evaluating the number of patients seen, the average
waiting time of patients and the total time the doctor has to stay. This problem is worth 2 points
in terms of Effort.
b) Add a schedule to the patient arrival table in the simulation “HW_7_06.spfx” where (i) 2 patients are
scheduled every 20 minutes, (ii) another schedule where 3 patients are scheduled every 20 minutes
and (iii) another schedule where 1 patient is scheduled every 9 minutes. Add a reference property
“ArrivalTimeProperty” to the experiment and run 4 scenarios, the first one using the schedule
under question (a) and the other three scenarios using the three scheduling methods (i), (ii) and
(iii) above. Run the Experiment for 500 Replications. This problem is worth 2 point in terms of
Effort.
c) What are your conclusions based on the analysis result under b? This problem is worth 1
point in terms of Effort.
Homework 2: HW_7_07 in the book
a) Download the simulation “Model 7_2.spfx” and add a “Severe_to_Urgent” Patient to the “PatienData”
Table. Save the file as “HW_7_07.spfx”. Add a “Real” Column called “HW_7_07_MIX” and set the
percentages to the percentages provided in Homework 7-07 from the book. Add to the Sequence
Column the info for “Severe_To_Urgent” patients in the “Treatment_Table” while setting the
treatment time distributions of the “Severe_To_Urgent” patients in the Trauma and Treatment
Rooms equal to those of the “Urgent” patients. This problem is worth 1 points in terms of Effort.
b) Add reference property “Patient_Mix” to the Experiment of “Homewor_7_07.spfx” and add a
Scenario to the experiment called “HW_7_07_Mix”, change the Patient Mix to that of HW_7_07. Add a
Response Variable for the W (Time in System) and the Througput (Number of Patients server per
hour) and rerun the experiment for 100 replications. Save the simulation model as “HW_7_07.spfx”.
This problem is worth 1 point in terms of Effort.
c) Copy the workbook “Steady State Calculation Model 7_2.xlsx” and name it workbook “Steady State
Calculation HW 7_07.xlsx . In this new workbook copy the worksheet “Model 7-2” and rename this
sheet “HW_7_07”. Modify the worksheet HW_7_07 by setting the patient mix percentages to the
percentages in HW_7_07 at each of the servers “SIGNIN”, “REGISTRATION”, ‘EXAM ROOM”,
TRAUMA ROOM” and “TREATMENT ROOM and re-evaluate the Steady State Results for their
utilizations. This problem is worth 1 point in terms of Effort.
d) Compare the steady results for the new patient mix in the worksheet “HW_7_07” to the scenario
results in SIMIO using SMORE plots and also compare the results using the HW_7_07 patient mix to
the original patient mix of Model 7-2. What are your conclusions? This problem is worth 1
point in terms of Effort.

Statistics homework help

/in /by
Unit 6 Discussion
In this discussion, you will explore how you can apply descriptive statistics, probability calculations, normal distribution calculations, hypothesis testing, regression, and forecasting to current events.
Research an article on a current event that centers on a controversial issue where the two sides are claiming opposing views. Then, describe how you would analyze the situation to settle the issue if you were involved in this event. For example, if the article was about whether a proposed new law about gun control will reduce deaths, you may describe how you would use hypothesis testing to compare data from states where such laws exist. Or, if the article was about actions to take to reduce gas prices, you could talk about how you would use regression to figure out which factors affected prices at the pump the most. General discussions like “should marijuana be legal” or “do vaccines cause autism” are not appropriate. Pick a current and specific debate.
Please note that this discussion should be limited to how statistical analysis can be applied to current issues. This is not the place to champion a particular position on the issue you are discussing or get into an argument about the various sides of an issue. Remember, you are here to analyze, not proselytize.
Also note that the article you are citing must be discussing the opposing views on the issue. Do not introduce your own perspective on what is being disputed. For example if the article is about the new budget being passed but does not discuss any conflicts of opinion, it doesn’t qualify.
Please use the template below in your answers so everyone can easily follow your answers to all the questions (copy and paste to your post).
Use this template for your Unit 6 Discussion.
Summary of the article
Briefly describe the current event described in the article.
Central question
What does the article say about the issue being disputed? What are the conflicting points of view according to the article? Use direct quotes from the article to summarize the dispute and the opposing sides.
There has to be some specific issue in dispute at the center (do tax breaks increase spending, what impacts health care costs the most, etc.), and the sides have to be defending a particular position.
Do not use examples where the issue is based on opinions or morality. For example, “Should abortion be legal?” is largely a morality question and is not suitable for statistical analysis. Conducting a survey to ask people about their opinions is not the same as analyzing data and making conclusions- you still only have opinions.
Methodology
Explain which methodology you will apply. Provide the relevant details. Where will your data come from? How will the results from this methodology answer the question you described above?
If you are going to use forecasting, explain how you will do that (which methodology and why) and how you will measure your accuracy. How will the forecast settle the issue?
If you do a regression analysis, explain what the dependent and independent variables will be.
If you will do hypothesis testing, what will the null and alternative hypothesis be?

Statistics homework help

/in /by
Unit 6 Discussion
In this discussion, you will explore how you can apply descriptive statistics, probability calculations, normal distribution calculations, hypothesis testing, regression, and forecasting to current events.
Research an article on a current event that centers on a controversial issue where the two sides are claiming opposing views. Then, describe how you would analyze the situation to settle the issue if you were involved in this event. For example, if the article was about whether a proposed new law about gun control will reduce deaths, you may describe how you would use hypothesis testing to compare data from states where such laws exist. Or, if the article was about actions to take to reduce gas prices, you could talk about how you would use regression to figure out which factors affected prices at the pump the most. General discussions like “should marijuana be legal” or “do vaccines cause autism” are not appropriate. Pick a current and specific debate.
Please note that this discussion should be limited to how statistical analysis can be applied to current issues. This is not the place to champion a particular position on the issue you are discussing or get into an argument about the various sides of an issue. Remember, you are here to analyze, not proselytize.
Also note that the article you are citing must be discussing the opposing views on the issue. Do not introduce your own perspective on what is being disputed. For example if the article is about the new budget being passed but does not discuss any conflicts of opinion, it doesn’t qualify.
Please use the template below in your answers so everyone can easily follow your answers to all the questions (copy and paste to your post).
Use this template for your Unit 6 Discussion.
Summary of the article
Briefly describe the current event described in the article.
Central question
What does the article say about the issue being disputed? What are the conflicting points of view according to the article? Use direct quotes from the article to summarize the dispute and the opposing sides.
There has to be some specific issue in dispute at the center (do tax breaks increase spending, what impacts health care costs the most, etc.), and the sides have to be defending a particular position.
Do not use examples where the issue is based on opinions or morality. For example, “Should abortion be legal?” is largely a morality question and is not suitable for statistical analysis. Conducting a survey to ask people about their opinions is not the same as analyzing data and making conclusions- you still only have opinions.
Methodology
Explain which methodology you will apply. Provide the relevant details. Where will your data come from? How will the results from this methodology answer the question you described above?
If you are going to use forecasting, explain how you will do that (which methodology and why) and how you will measure your accuracy. How will the forecast settle the issue?
If you do a regression analysis, explain what the dependent and independent variables will be.
If you will do hypothesis testing, what will the null and alternative hypothesis be?

Numerical analysis homework help

/in /by

Discussion

The discussion assignment provides a forum for discussing relevant topics for this week based on the course competencies covered.
For this assignment, make sure you post your initial response to the Discussion Area by the due date assigned.
To support your work, use your course and text readings and also use outside sources. As in all assignments, cite your sources in your work and provide references for the citations in APA format.
Start reviewing and responding to the postings of your classmates as early in the week as possible. Respond to at least two of your classmates. Participate in the discussion by asking a question, providing a statement of clarification, providing a point of view with a rationale, challenging an aspect of the discussion, or indicating a relationship between two or more lines of reasoning in the discussion. Complete your participation for this assignment by the end of the week.

Hypothesis Testing

Hypothesis testing is a well-structured process that consists of several logical steps, and it aims at refining a business decision.
Hypothesis testing is a quite common technique used by researchers. With regard to hypothesis testing, answer the following questions.

  • What are the steps to conduct a hypothesis test? How does a researcher determine which statistical test to conduct?
  • How does a researcher determine which level of significance to use?
  • What software programs can be used to compute these tests? Where is the critical test value found?
  • How can one determine if the null hypothesis should be rejected?
  • Give a business example on each of the three possible cases of hypothesis testing. Do you think the rejection region will be different in each one of the three cases? Why? Why not?

Justify your answers using examples and reasoning. Comment on the postings of at least two peers and state whether you agree or disagree with their views.

Numerical analysis homework help

/in /by
Deliverable 07 Worksheet – PLEASE READ ALL THE WAY TO THE BOTTOM !!!MUST submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document. EXCEL WORKBOOK MUST CONTAIN EXCEL FORMULAS THAT SHOW THE ANSWERS ASKED FOR USING THE DATA FROM THE ATTACHMENT.
Scenario
You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past few days, you have noticed an increase in patients admitted with a particular infectious disease. You believe that the ages of these patients play a critical role in the method used to treat the patients. You decide to speak to your manager, and together you work to use statistical analysis to look more closely at the ages of these patients.
You do some research and put together a spreadsheet (THE SPREADSHEET IS ATTACHED, USE THIS SPREADSHEET FOR YOUR DATA) of the data that contains the following information:
● Client number
● Infection disease status
● Age of the patient
You need the preliminary findings immediately so that you can start treating these patients. So, let’s get to work!
Background information on the Data:
The data set consists of 60 patients that have the infectious disease with ages ranging from 35 years of age to 76 years of age for NCLEX Memorial Hospital.
Requirements:
1) Answer the questions below in a PowerPoint presentation. 
2) Include only the summary calculations in your slides (not formulas). 
3) Show calculations in your Excel spreadsheet (include formulas and do not round the numbers).
● Slide 1: Title
● Introduce your scenario and data set.
○ Slide 2: Provide a brief overview of the scenario you are given above and the data set that you will be analyzing.
o Slide 3: Classify the variables in your data set.
▪ Which variables are quantitative/qualitative?
▪ Which variables are discrete/continuous?
▪ Describe the level of measurement for each variable included in the data set (nominal, ordinal, interval, ratio)
● Discuss the importance of the Measures of Center and the Measures of Variation.
o Slide 4: What are the measures of center and why are they important?
o Slide 5: What are the measures of variation and why are they important?
● Slide 6: Calculate the measures of center and measures of variation. Interpret your results in context of the scenario.
o Mean
o Median
o Mode
o Midrange
o Range
o Variance
o Standard deviation
4. Slide 7: Discuss the importance of constructing confidence intervals for the population mean by answering these questions:
o What are confidence intervals?
o What is a point estimate?
o What is the best point estimate for the population mean? Explain.
o Why do we need confidence intervals?
5. Slide 8: Construct a 95% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown. Include a statement that correctly interprets the confidence interval in context of the scenario.
6. Perform the following hypothesis test:
o Original Claim: The average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.
▪ Test the claim using α = 0.05 and assume your data is normally distributed and σ is unknown.
o Answer the following:
1. Slide 9: Write the null and alternative hypothesis symbolically and identify which hypothesis is the claim.
2. Slide 9: Is the test two-tailed, left-tailed, or right-tailed? Explain.
3. Slide 10: Which test statistic will you use for your hypothesis test; z-test or t-test? Explain.
4. Slide 10: What is the value of the test-statistic? What is the p-value? What is the critical value?
5. Slide 11: What is your decision; reject the null hypothesis, or do not reject the null hypothesis?
a. Explain why you made your decision, including the results for your p-value and the critical value.
6. Slide 11: State the final conclusion in nontechnical terms.
7. Slide 12: Conclude by recapping your ideas by summarizing the information presented in context of the scenario.
o Include the mean, standard deviation, confidence interval with interpretation, and results of the hypothesis test.
o What conclusions, if any, do you believe you can draw as a result of your study?
o What did you learn from the project about the population based on this sample? What did you learn about the specific statistical tests you conducted?
!!!MUST submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document. EXCEL WORKBOOK MUST CONTAIN EXCEL FORMULAS THAT SHOW THE ANSWERS ASKED FOR USING THE DATA FROM THE ATTACHMENT.
  • attachment

    Deliverable_07_Data2.xlsx

Numerical analysis homework help

/in /by
Deliverable 07 Worksheet – PLEASE READ ALL THE WAY TO THE BOTTOM !!!MUST submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document. EXCEL WORKBOOK MUST CONTAIN EXCEL FORMULAS THAT SHOW THE ANSWERS ASKED FOR USING THE DATA FROM THE ATTACHMENT.
Scenario
You are currently working at NCLEX Memorial Hospital in the Infectious Diseases Unit. Over the past few days, you have noticed an increase in patients admitted with a particular infectious disease. You believe that the ages of these patients play a critical role in the method used to treat the patients. You decide to speak to your manager, and together you work to use statistical analysis to look more closely at the ages of these patients.
You do some research and put together a spreadsheet (THE SPREADSHEET IS ATTACHED, USE THIS SPREADSHEET FOR YOUR DATA) of the data that contains the following information:
● Client number
● Infection disease status
● Age of the patient
You need the preliminary findings immediately so that you can start treating these patients. So, let’s get to work!
Background information on the Data:
The data set consists of 60 patients that have the infectious disease with ages ranging from 35 years of age to 76 years of age for NCLEX Memorial Hospital.
Requirements:
1) Answer the questions below in a PowerPoint presentation. 
2) Include only the summary calculations in your slides (not formulas). 
3) Show calculations in your Excel spreadsheet (include formulas and do not round the numbers).
● Slide 1: Title
● Introduce your scenario and data set.
○ Slide 2: Provide a brief overview of the scenario you are given above and the data set that you will be analyzing.
o Slide 3: Classify the variables in your data set.
▪ Which variables are quantitative/qualitative?
▪ Which variables are discrete/continuous?
▪ Describe the level of measurement for each variable included in the data set (nominal, ordinal, interval, ratio)
● Discuss the importance of the Measures of Center and the Measures of Variation.
o Slide 4: What are the measures of center and why are they important?
o Slide 5: What are the measures of variation and why are they important?
● Slide 6: Calculate the measures of center and measures of variation. Interpret your results in context of the scenario.
o Mean
o Median
o Mode
o Midrange
o Range
o Variance
o Standard deviation
4. Slide 7: Discuss the importance of constructing confidence intervals for the population mean by answering these questions:
o What are confidence intervals?
o What is a point estimate?
o What is the best point estimate for the population mean? Explain.
o Why do we need confidence intervals?
5. Slide 8: Construct a 95% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown. Include a statement that correctly interprets the confidence interval in context of the scenario.
6. Perform the following hypothesis test:
o Original Claim: The average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.
▪ Test the claim using α = 0.05 and assume your data is normally distributed and σ is unknown.
o Answer the following:
1. Slide 9: Write the null and alternative hypothesis symbolically and identify which hypothesis is the claim.
2. Slide 9: Is the test two-tailed, left-tailed, or right-tailed? Explain.
3. Slide 10: Which test statistic will you use for your hypothesis test; z-test or t-test? Explain.
4. Slide 10: What is the value of the test-statistic? What is the p-value? What is the critical value?
5. Slide 11: What is your decision; reject the null hypothesis, or do not reject the null hypothesis?
a. Explain why you made your decision, including the results for your p-value and the critical value.
6. Slide 11: State the final conclusion in nontechnical terms.
7. Slide 12: Conclude by recapping your ideas by summarizing the information presented in context of the scenario.
o Include the mean, standard deviation, confidence interval with interpretation, and results of the hypothesis test.
o What conclusions, if any, do you believe you can draw as a result of your study?
o What did you learn from the project about the population based on this sample? What did you learn about the specific statistical tests you conducted?
!!!MUST submit your PowerPoint presentation and the Excel workbook showing your work. Do not submit your Word document. EXCEL WORKBOOK MUST CONTAIN EXCEL FORMULAS THAT SHOW THE ANSWERS ASKED FOR USING THE DATA FROM THE ATTACHMENT.
  • attachment

    Deliverable_07_Data2.xlsx

Geometry homework help

/in /by
 . For the three-part question that follows, provide your answer to each question in the given workspace. Identify each part with a coordinating response. Be sure to clearly label each part of your response as Part A, Part B, and Part C.
Part A: Provide an example of 3 lengths that can be used to create a unique triangle.
Part B: Prove the side lengths will form a unique triangle using the triangle inequality theorems.
Part C: Explain why a unique triangle is formed with the chosen side lengths.

Geometry homework help

/in /by
 . For the three-part question that follows, provide your answer to each question in the given workspace. Identify each part with a coordinating response. Be sure to clearly label each part of your response as Part A, Part B, and Part C.
Part A: Provide an example of 3 lengths that can be used to create a unique triangle.
Part B: Prove the side lengths will form a unique triangle using the triangle inequality theorems.
Part C: Explain why a unique triangle is formed with the chosen side lengths.