Sheet1

Region NumberOfEmployees InventoryValue AverageMonthlyOrders
1 4 690.23 277
1 2 786.10 254
1 5 764.79 244
1 5 766.59 259
1 6 729.11 238
1 7 687.91 245
1 7 724.88 238
1 8 817.39 232
1 8 785.23 258
1 8 756.49 265
1 9 757.32 257
1 9 670.83 231
1 10 684.18 235
1 10 789.23 243
1 10 705.89 250
1 10 704.03 261
1 11 699.69 262
1 11 756.45 231
1 11 728.59 214
1 11 668.52 286
1 11 683.30 294
1 11 656.70 281
1 11 826.58 289
1 11 715.32 283
1 11 747.24 286
1 11 720.59 283
1 12 811.53 280
1 12 747.63 273
1 12 725.63 273
1 12 769.11 267
2 12 726.56 273
2 12 781.35 271
2 12 767.29 279
2 12 688.26 275
2 13 762.97 269
2 13 771.11 285
2 13 739.76 289
2 14 637.04 293
2 14 828.24 284
2 14 740.42 294
2 14 787.41 309
2 14 786.27 309
2 15 674.31 314
2 15 731.20 294
2 15 748.92 287
2 16 746.96 289
2 16 712.93 309
2 16 806.78 320
2 16 789.56 296
2 17 748.03 295
2 17 713.43 295
2 17 706.83 313
2 17 668.78 310
2 17 673.44 326
2 17 726.98 318
2 17 648.94 308
2 17 729.23 293
2 17 662.34 298
2 17 764.95 313
2 18 699.68 293
2 18 624.28 317
3 18 779.76 322
3 18 802.43 304
3 18 705.70 325
3 18 769.53 315
3 18 697.75 312
3 18 703.19 291
3 18 802.11 321
3 18 829.01 323
3 19 642.04 307
3 19 743.34 303
3 19 806.15 317
3 19 726.79 334
3 19 798.96 329
3 19 825.26 319
3 19 731.59 320
3 19 758.99 330
3 20 696.83 322
3 20 765.86 304
3 20 752.32 326
3 20 770.93 340
3 20 792.70 342
3 20 751.65 335
3 20 688.28 334
3 21 702.71 335
3 21 754.76 329
3 21 761.71 342
3 21 748.24 341
3 21 860.08 334
3 21 742.45 336
3 21 755.89 315
4 21 729.06 329
4 21 787.64 329
4 21 769.55 332
4 22 703.16 358
4 22 702.56 343
4 22 727.73 347
4 22 743.37 352
4 22 822.47 341
4 22 761.24 342
4 22 691.18 359
4 22 789.95 372
4 22 744.59 365
4 22 726.61 361
4 22 737.28 369
4 23 718.90 370
4 23 765.29 378
4 23 767.18 370
4 23 758.12 350
4 23 641.52 357
4 23 787.04 360
4 23 749.75 352
4 23 773.87 365
4 24 702.89 365
4 24 676.57 354
4 25 758.38 360
4 25 659.60 361
4 25 803.99 384
4 25 726.94 357
4 25 695.81 378
4 25 668.78 371
5 25 702.83 377
5 25 607.26 379
5 25 778.38 397
5 25 754.31 400
5 26 803.36 377
5 26 794.51 376
5 26 656.43 365
5 26 695.72 376
5 26 708.65 366
5 26 760.02 357
5 26 739.45 373
5 26 728.87 376
5 27 697.90 365
5 27 683.49 372
5 27 802.57 374
5 27 683.04 384
5 28 725.09 367
5 28 722.32 379
5 28 757.80 374
5 29 743.25 417
5 30 705.61 429
5 30 823.40 413
5 31 705.24 411
5 31 792.83 388
5 32 687.52 448
5 32 819.91 406
5 34 743.38 440
5 37 728.13 456
5 40 652.08 429

3

Care of Elderly Hypertensive Patients in Minnesota

Student's Name

Institutional Affiliation

Instructor

Course

Date

Care of Elderly Hypertensive Patients in Minnesota

Introduction

Hypertension is a chronic illness that affects millions of people across the globe. The twenty-first century has particularly been plagued with lifestyle diseases, and hypertension has been among those whose prevalence has increased. Multiple factors have contributed to this phenomenon. Among them are improved living standards so people can access better healthcare. Thus, the disease is effectively diagnosed and managed with minimal complications. The result has been increased life expectancy. The elderly population with hypertension thus present a special challenge in meeting their needs. The United States has taken various measures to deliver patient-centred care to its citizens. Minnesota is one such state that has dedicated itself to channeling state and national resources toward enabling a safe and effective formula to transition care to older patients.

Outline

Caring for Elderly Hypertensive Patients in Minnesota

I. Hypertension is a chronic illness that affects millions of people across the globe.

A. The twenty-first century has particularly been plagued with diseases

B. Multiple factors have contributed to this phenomenon

1. Improvement in standards of living is a cause of increasing chronic conditions (Brewer et al., 2020).

C. The elderly population with hypertension present a special challenge in meeting their needs.

D. The United States has taken various measures to deliver patient-centred care to its citizens.

1. Minnesota is one such state that has dedicated itself to channelling state and national resources toward enabling a safe and effective formula to transition care to older patients (Brewer et al., 2020).

II. Equipping telenursing communication in Minnesota is an important adjunct in transitioning care.

A. Telenursing is among the modern means of patient follow-up.

1. Telenursing has increased patient independence outside the hospital environment (Madadkar et al., 2021).

2. The use of telenursing reduces the number of hospital visits post-admission and smooth transitions for elderly patients in Minnesota (Brewer et al., 2020).

B. Digital knowledge is now a basic requirement for healthcare practitioners in Minnesota.

1. The use of modern technologies such as video conferencing apps necessitates that care providers be conversant with them for smooth service delivery (Brewer et al., 2020).

III. Health information systems (HISs) are an important centre in care transitions.

A. HISs such as electronic health records are among Minnesota's new service delivery trends.

1. Well-designed electronic health records are hack-proof to guarantee patient information privacy while allowing easy follow-up on hypertensive patients between different care providers (Brewer et al., 2020).

2. The EHR is central to keeping long-term data for chronic illnesses such as hypertension, allowing early detection of complications (Brewer et al., 2020).

B. Effective working of HIS requires that most elderly patients with hypertension have access to digital communication.

1. Conscious efforts have been undertaken in Minnesota to link the care centre with family caregivers who are likely to be conversant with the use of modern technology (Brewer et al., 2020).

C. The need to have family caregivers is important, especially for very elderly patients.

1. At a very advanced age, senile problems such as dementia render one dependent on care providers (Madadkar et al., 2021).

2. Care providers with good access to digital healthcare ensure the elderly population is well cared for (Madadkar et al., 2021).

Conclusion

Care for the elderly with chronic comorbidities such as hypertension requires an effective transition from the hospital to a remote setting. Minnesota is well aware of the importance of using technology and family caregivers in making the transition possible. Thus significant resources have been channelled to platforms such as telehealth and health information systems up to date with the latest technology. There is also a conscious effort to ensure there are family caregivers for the elderly with hypertension to meet their requirements. Ultimately, the quality of life will be prolonged even more through the facilitation of effective care transition.

References

Brewer, L. C., Fortuna, K. L., Jones, C., Walker, R., Hayes, S. N., Patten, C. A., & Cooper, L. A. (2020). Back to the future: achieving health equity through health informatics and digital health. JMIR mHealth and uHealth, 8(1), e14512. https://preprints.jmir.org/preprint/14512?

Madadkar Dehkordi, S., Okhovat, F., & Karimiankakolaki, Z. (2021). Designing a Clinical Trial Protocol about the Impact of Family-Based Multimedia Education Based on Telephone Tracking (Tele Nursing) to Improve the Quality of Life and Self-Efficacy in Patients with Myocardial Infarction. International journal of surgery protocols, 25(1), 92–97. https://doi.org/10.29337/ijsp.146

Simple Regression Preliminary Analysis Report

Assumption for the analysis: Let us assume each row in dataset indicates the values in a calendar

month.

a) comp.million : Compensation given to ‘n’ the employees working at the time, in millions. b)

sales : Sales in millions.

c) No. employees : Total number of employees working in the given month.

d) Cap. Investment : Amount invested in the company in a given month in millions.

e) Manufacturing : Indication if the row values are relevant to manufacturing or not.

1. YOU MUST HAVE the Data Analysis Tool Pack add-in installed to complete this assignment. Please

review the notes for the week regarding how to use the Regression tool within the Data Analysis

Tool Pack.

2. Use Excel to calculate and the report the correlation number for all candidate variables for this

analysis. Interpret the result of the correlation number by discussing the linear strength and

direction of the relations observed.

A: The correlation coefficient can range between -1 and +1. A value 0 means there is no linear

correlation between the 2 variables. A value of 1 means there is a perfectly positive linear correlation

and a positive number, between 0 and 1 indicates that a variable increases in value along with the other

by the said factor. -1 means there is a perfectly negative correlation and a negative value indicates that a

value decreases as the other value increases by the said factor.

With the above understanding, we can interpret that compensation, sales, no. of employees, and

investment variables are all strongly corelated linearly, although not perfectly since the numbers

highlighted in green are very close to 1. This indicates that an increase of each of these variables, has a

direct impact on the others positively.

Manufacturing, on the other hand, has weak positive correlation with compensation, employees and

investment (highlighted in blue) and a slightly negative impact on sales(highlighted in red). This indicates

that the sales values relatively drops with manufacturing, but manufacturing variable doesn’t have a

major impact on rest of the variables.

Table 1: Correlation matrix of all candidate variables in dataset

comp.million sales no.employees cap.investment manufacturing

comp.million 1 sales 0.950554719 1 no.employees 0.955076813

0.997065477 1 cap.investment 0.922777565 0.994771967 0.990264565 1

manufacturing 0.015793034 -0.003322363 0.055742601 0.01950762 1

3. Select 1 variable to use as an explanatory and one as a response variable. State your choices

A: Explanatory variable (x) – Capital Investment

Response variable (y) – Sales

4. Use Excel to generate and report a scatter plot for the 2 variables. The Explanatory variable should

be on the horizontal axis. Interpret the form and direction of the plot. Format chart to class

expectations.

A: We can interpret from the above graph that with the increase in investment, the sales have

increased. Hence, we can conclude that the variables being studied have a positive linear

association.

Figure 1: Scatter plot of Sales with respect to Capital investment (both in millions)

5. Using only the visual inspection of the scatter plot, is a transformation warranted? Please review

course notes and use what you notice about the dot pattern within the scatter plot as evidence to

support your answer.

A: Figure 1, shows a positive linear association and if we were to draw a regression line, it would be

pretty close to the plotted variables. Transformations are warranted when ‘residual’ values are high

and thus applied on explanatory variable, response variable, or both, on a trial and error basis until

we find a best fit to match a linear regression equation. Transformations can be a Log, Ln, square

root, reciprocal or exponential functions. Once we have an equation that brings the scatter plot dots

close enough to the regression line, we can then predict values on both higher and lower ends of

the variables by evaluating the equation. But since in this case, we have a scatter plot that is already

close to the imaginary regression line, a transformation is not warranted.

6. Use the Data Analysis Tool pack to run the regression analysis over your variables to generate a

residual plot in MS Excel for these variables. DO NOT INTERPRET NOR REPORT THE NUMERICAL

SUMMARIES generated in the regression tables. Only examine the residual plot generated by Excel.

Copy and Paste ONLY the residual plot into your preliminary report. Using only your visual

0.0

100.0

200.0

300.0

400.0

500.0

600.0

700.0

800.0

900.0

0.0 50.0 100.0 150.0 200.0 250.0 300.0

Capital investment in millions

inspection of the residual plot, is a transformation warranted? Review course notes and use what

you notice about the dot pattern within the residual plot to support your answer.

A: Residuals and residual plots determine how well a regression line describes the data. This can be

confirmed if no obvious pattern is observed in a residual plot and if the residuals are relatively small

in size. In Figure 2 below, though we do not see an obvious pattern, we do see 2 values (marked in

red) that are far from the regression line with a deviation of about +40 and -60 units. Also, 4 plots

between +20 and +40 units on the Residual axis(marked in green). This does not warrant for much

of a deviation, but since in our case, we are dealing with values in millions, I believe this can have a

significant effect and warrants a transformation. As we move from left to right on the x-axis, we can

see that the spread increases in the top half indicating that our transformation may be warranted.

Figure 2: Excel graph of Residual plot of Sales (response variable)

7. Check the 4 simple regression assumptions (linearity, normality, equal variance, independence).

Reference class notes so that you are clear how to perform these checks using the Excel worksheet .

Create 4 subheadings to discuss EACH of the 4 assumptions indicating if the assumptions were met

or were violated. Under each subheading, also include (or reference by name and number ‘Table

1, Figure 2 etc …) any tables or charts you’ve generated as evidence for your conclusions. Format all

charts and tables to class expectations (see exemplar). Your claims regarding the assumptions must

be based on content contained within the tables, numerical summaries , or charts that you

generated. Please reference them by name in your write up. For instance “ It can be seen in Figure

1 ….” Etc …

A: For a dataset to be eligible for a simple linear regression, all 4 assumptions mentioned below

should be satisfied. I will assess the same for sales and capital investment variables assessing their

properties for each.

-80

-60

-40

-20

0

20

40

60

0 100 200 300 400 500 600 700 800 900

Sales

Linearity: Linearity can be checked from a scatter plot to see what type of correlation it displays i.e.

positive, negative, or none. Since the scatter plot below displays positive linearity, the linearity

assumption is met and Sales and Capital investment data are eligible for linear regression analysis.

Figure 3: Regression line for the scatter plot data

Independence: Here, we only see if there exists a positive, negative or no correlation in the residual

plot and since Figure 2 showing residual plot of sales does not display correlation between the 2

variables and appear to be random, we are good to use this data for a linear regression. To support

this theory, applying =correl(<predicted_sales>,<residuals>) formula in excel fetches the

value -2.98663𝑒!"# which is very close to zero.

Normality: To check the normality, a probability plot of residuals are used as shown in Figure 4

below. The rule is that normality assumption is considered met if the dot pattern closely follows the

trend line, and depending on what pattern it follows, we can deduce the shape of the curve to be

normal, skewed left or right, thick or thin tailed. Figure 4 shows the plots following the trend line

and this specific pattern indicates the data is skewed to the left thus proving the data is good fit for

linear regression.

y = 3.0108x + 23.287 R² = 0.9896

0.0

100.0

200.0

300.0

400.0

500.0

600.0

700.0

800.0

900.0

1000.0

0.0 50.0 100.0 150.0 200.0 250.0 300.0

Capital Investment in millions

Figure 4: Normality probability Plot of residuals of Sales

Equal variance: To meet the assumption of variance, the variance of residuals should statistically be

the same across all values of the explanatory variable – meaning it should have a scattered dot

pattern where the variance across values is consistent. In figure 5 below we can notice that most of

the values after ~75 on the x-axis is positive, leading to believe it is NOT statistically same across the

dataset, but again, the dot plot at the extreme right shows a -60 on the y-axis. Due to this, I’m

inclined to trust that the data meets the assumption of variance to an extent and considering the

rest of the assumptions being met, I conclude the data qualifies for linear regression.

Figure 5: Excel graph of Residual plot of Capital investment (exploratory variable)

-200

0

200

400

600

800

1000

-10 10 30 50 70 90 110

Sample Percentile

-80

-60

-40

-20

0

20

40

60

0.0 50.0 100.0 150.0 200.0 250.0 300.0

Capital Investment

Simple Regression Preliminary Analysis Report Guide

Please submit preliminary report writeup, to Moodle discussion as an attachment in PDF format only. Tables, charts, and graphs should be formatted as expected for the class. Font size of 11 pt or higher.  DO NOT SUBMIT YOUR EXCEL DATASET.  Copy and paste the numerical prompts below into your submission document and record your responses , as applicable, directly beneath. Include the following in your submission:

Simple Regression Pre-analysis (include ALL charts, graphs and tables you generate formatted to class expectations). Assume all variables (with the exception of the subject variable) are ratio level.

1. YOU MUST HAVE the Data Analysis Tool Pack add-in installed to complete this assignment. Please review the notes for the week regarding how to use the Regression tool within the Data Analysis Tool Pack.

2. Use Excel to calculate and the report the correlation number for all candidate variables for this analysis. Interpret the result of the correlation number by discussing the linear strength and direction of the relations observed .

3. Select 1 variable to use as an explanatory and one as a response variable. State your choices

4. Use Excel to generate and report a scatter plot for the 2 variables. The Explanatory variable should be on the horizontal axis. Interpret the form and direction of the plot. Format chart to class expectations.

5. Using only the visual inspection of the scatter plot, is a transformation warranted? Please review course notes and use what you notice about the dot pattern within the scatter plot as evidence to support your answer.

6. Use the Data Analysis Tool pack to run the regression analysis over your variables to generate a residual plot in MS Excel for these variables. DO NOT INTERPRET NOR REPORT THE NUMERICAL SUMMARIES generated in the regression tables. Only examine the residual plot generated by Excel. Copy and Paste ONLY the residual plot into your preliminary report. Using only your visual inspection of the residual plot, is a transformation warranted? Review course notes and use what you notice about the dot pattern within the residual plot to support your answer.

7. Check the 4 simple regression assumptions (linearity, normality, equal variance, independence). Reference class notes so that you are clear how to perform these checks using the Excel worksheet . Create 4 subheadings to discuss EACH of the 4 assumptions indicating if the assumptions were met or were violated. Under each subheading, also include (or reference by name and number ‘Table 1, Figure 2 etc …) any tables or charts you’ve generated as evidence for your conclusions. Format all charts and tables to class expectations (see exemplar). Your claims regarding the assumptions must be based on content contained within the tables, numerical summaries , or charts that you generated. Please reference them by name in your write up. For instance “ It can be seen in Figure 1 ….” Etc …

Previous Next

Get help from top-rated tutors in any subject.

Efficiently complete your homework and academic assignments by getting help from the experts at homeworkarchive.com