Category: Mathematics Homework Help

Perform multiple regression on the relationship between hospital costs and patient age, risk factors, and patient satisfaction scores, and then generate a prediction to support this health care decision. Write a 3-4 page analysis of the results in a Word document and insert the test results into this document.

Introduction
Note: You are strongly encouraged to complete the assessments in this course in the order they are presented.Regression is an important statistical technique for determining the relationship between an outcome (dependent variable) and predictors (independent variables). Multiple regression evaluates the relative predictive contribution of each independent variable on a dependent variable. The regression model can then be used for predicting an outcome at various levels of the independent variables. For this assessment, you will perform multiple regression and generate a prediction to support a health care decision.Overview & Preparation
Download the Assessment 3 Dataset [XLSX]. The dataset contains the following variables:

cost? (hospital cost in dollars)?.

• age (patient age in years)?.

risk (count of patient risk factors).

satisfaction (patient satisfaction score percentile rank)?.

Instructions
Hospital administration needs to make a decision on the amount of reimbursement required to cover expected costs for next year. For this assessment, using information on hospital discharges from last year, perform multiple regression on the relationship between hospital costs and patient age, risk factors, and patient satisfaction scores, and then generate a prediction to support this health care decision. Write a 3–4 page analysis of the results in a Word document and insert the test results into this document (copied from the output file and pasted into a Word document). Refer to Copy From Excel to Another Office Program for instructions.Submit both the Word document and the Excel file that shows the results.Grading Criteria
The numbered assessment instructions outlined below correspond to the grading criteria in the Predicting an Outcome Using Regression Models Scoring Guide, so be sure to address each point. You may also want to review the performance-level descriptions for each criterion to see how your work will be assessed.

Perform the appropriate multiple regression using a dataset.

Interpret the statistical significance and effect size of the regression coefficients of a data analysis.

Interpret p-value and beta values.

• Interpret the fit of the regression model for prediction of a data analysis.
• Interpret R-squared and goodness of fit.
• Apply the statistical results of the multiple regression of a data analysis to support a health care decision.
• Generate a prediction with regression equation.
• Write a narrative summary of the results that includes practical, administration-related implications of the multiple regression.

I’m working on a calculus question and need a reference to help me learn.

1. Miguel leased equipment worth $60,000 for 7 years. If the lease rate is 6.50% compounded semi-annually, calculate the size of the lease payment that is required to be made at the beginning of each half-year.

---

Round to the nearest cent

2. Dustin saved $100 at the end of every month for 4 years in his bank account that earned 3.50% compounded monthly.

---

a. What is the accumulated value of his savings at the end of the period?

$5,029.54

$5,144.21

$73,600.97

$344.21

---

b. What is the interest earned over the period?

$244.21

$5,144.21

$444.21

$344.21

3. Your RRSP savings of $50,000 are converted to a RRIF at 3.34% compounded monthly that pays $5,138 at the beginning of every month. After how many payments will the fund be depleted?

Round to the next payment

4. Calculate the accumulated amount of end-of-month payments of $3,500 made for 6 years into an investment fund that earns 4.50% compounded quarterly.

Round to the nearest cent

5. Miguel wants to set up a fund for his son’s education such that he could withdraw $2,268.00 at the beginning of every 3 months for the next 3 years. If the fund can earn 2.70% compounded semi-annually, what amount could he deposit today to provide the payment?

Round your answer to the nearest cent

6. Ariel receives $2,800 from an investment at the beginning of every half-year for 12 years and 6 months at 3.98% compounded monthly.

---

a. What type of annuity is this?

Ordinary simple annuity

Ordinary general annuity

Simple annuity due

General annuity due

---

b. How many payments are there in this annuity?

Round up to the next payment

7. How much interest will an account earn if you deposited $605 semi-annually for 11 years and the account earned 8.25% compounded semi-annually?

Round to the nearest cent

8. Nicholas made periodic deposits into a savings account at the end of every month for 5 years. The investments were earning 7.50% compounded quarterly and grew to $13,750.00 at the end of 5 years.

---

a. Calculate the size of the month-end deposits.

$193.67

$189.81

$125.87

$186.09

---

b. How long will it take for the $13,750.00 to accumulate to $42,675.00 if the interest rate remained the same and he continued making the same month-end deposits throughout the term?

7 years and 10 months

11 years and 10 months

6 years and 10 months

6 years and 13 months

Your assignment this week is to complete an exercise using the One-Way Analysis of Variance (ANOVA) . The assignment consists of five (5) parts and the points assigned to each part is on the assignment page.

Alcorn State University hired an educational statistician to determine the job satisfaction of its’ instructors who had been employed for varying lengths of time. Length of employment is classified as follows: (1) 0 to 2 years, (2) 3 to 5 years, (3) 6 to 10 years, and (4) more than 10 years. The data in Table 1 below are job satisfaction scores for the instructors. Determine whether job satisfaction varies due to length of employment.

Table 1: Length of Employment

1 (0 to 2 yrs)	2 (3 to 5 yrs)	3 (6 to 10 yrs)	4 (more than 10 yrs)
71	77	83	76
74	74	77	69
75	81	80	64
68	75	76	76
74	70	86	73
72	74	79	72
76	81	86	68
73	76	82	71

1. State the null and alternative hypotheses (Ho and H1). – 10 points
2. What is the sample size (Ni), mean (x̄i), and standard deviation (Si) for each group? – 15 points
3. Make a decision about the null hypothesis. – 55 points

• Calculate the degrees of freedom (df) and set alpha (α).
• Identify the critical value (CV) and state the decision rule.
• Calculate the F-ratio (F) and create an ANOVA summary table.
• Make a decision whether to reject the null hypothesis
• Determine the level of significance.
• Calculate a measure of effect size (R2).

1. Draw a conclusion from the analysis. – 10 points
2. Relate the result of the analysis to the research hypothesis. – 10 points

The questions and data are attached.Data are in an excel file. questions are in the word document. the other file shows some sample graphs.

the due date is in 7 hours

I’m working on a mathematics question and need an explanation to help me study.

You will have to complete a sample essay on one of the two topics. It should contain 275-350 words, and be formatted according to the indicated formatting style. The file with your sample essay should be uploaded in doc / docx / pdf format (no handwritten essays are accepted).

My instructor said what I did is incorrect for week two assignment and he said I can revised it. So this is will be a revision. I will attached the one I did and please email me when you are ready for the instructions and I will email it to you and instructors feedback.

format APA

1 pages ( 275 words, Double spaced

I’m working on a mathematics project and need support to help me learn.

THE ONLY INSTRUCTION:

NO direct copy pasting, must be phrased or changed, till cannot be seen it is from any given answers.

Please still make sure it’s correct (as answers given).

https://drive.google.com/drive/folders/1gBsg1GxB75…

Both questions are in the following link. you need to use excel solver to do this assignment.

Everything is attached in this link:

https://www.dropbox.com/sh/wooytl4gijf91rq/AAAB6g8…

Scenario

You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the company’s Pacific region salespeople just returned to the office with a newly designed advertisement. It states that the average cost per square foot of his home sales is above the average cost per square foot in the Pacific region. He wants you to make sure he can make that statement before approving the use of the advertisement. The average cost per square foot of his home sales is $275. In order to test his claim, you collect a sample of 1,001 home sales for the Pacific region.

Prompt

Design a hypothesis test and interpret the results using significance level α = .05.

Use the House Listing Price by Region document to help support your work on this assignment. You may also use the Descriptive Statistics in Exceland Creating Histograms in Excel tutorials for support.

Specifically, you must address the following rubric criteria, using the Module Five Assignment Template.

• Setup: Define your population parameter, including hypothesis statements, and specify the appropriate test.
  • Define your population parameter.
  • Write the null and alternative hypotheses. Note: Remember, the salesperson believes that his sales are higher.
  • Specify the name of the test you will use.
    • Identify whether it is a left-tailed, right-tailed, or two-tailed test.
  • Identify your significance level.

• Data Analysis Preparations: Describe sample summary statistics, provide a histogram and summary, check assumptions, and find the test statistic and significance level.
  • Provide the descriptive statistics (sample size, mean, median, and standard deviation).
  • Provide a histogram of your sample.
  • Describe your sample by writing a sentence describing the shape, center, and spread of your sample.
  • Determine whether the conditions to perform your identified test have been met.

• Calculations: Calculate the p value, describe the p value and test statistic in regard to the normal curve graph, discuss how the p value relates to the significance level, and compare the p value to the significance level to reject or fail to reject the null hypothesis.
  • Determine the appropriate test statistic, then calculate the test statistic.
    Note: This calculation is (mean – target)/standard error. In this case, the mean is your regional mean (Pacific), and the target is 275.
  • Calculate the p value.
    Note: For right-tailed, use the T.DIST.RT function in Excel, left-tailed is the T.DIST function, and two-tailed is the T.DIST.2T function. The degree of freedom is calculated by subtracting 1 from your sample size.
    Choose your test from the following:
    =T.DIST.RT([test statistic], [degree of freedom])
    =T.DIST([test statistic], [degree of freedom], 1)
    =T.DIST.2T([test statistic], [degree of freedom])
  • Using the normal curve graph as a reference, describe where the p value and test statistic would be placed.

• Test Decision: Discuss the relationship between the p value and the significance level, including a comparison between the two, and decide to reject or fail to reject the null hypothesis.
  • Discuss how the p value relates to the significance level.
  • Compare the p value and significance level, and make a decision to reject or fail to reject the null hypothesis.

• Conclusion: Discuss how your test relates to the hypothesis and discuss the statistical significance.
  • Explain in one paragraph how your test decision relates to your hypothesis and whether your conclusions are statistically significant.

Guidelines for Submission

Submit the completed Module Five Assignment Template as a Word document that includes your response and supportive charts.