1.You wish to know the average GPA of MBA students at Whatsamatta U. Compute the 95% confidence interval of the mean using the sample of 200 students. Describe your findings.
2.You wish to know the proportion of MBA students that are majoring in Finance. Compute the 95% confidence interval of the proportion using the sample of 200 students. Describe your findings.
3.You wish to learn the average age of an MBA student within 2 years and with 99% confidence. How large of a sample should you get?
4.You wish to learn the proportion of MBA students that are female within 3%, and with 98% confidence. How large of a sample should you get?

Students

ID
Gender
Major
Employ
Age
MBA_GPA
BS GPA
Hrs_Studying
Works FT

1
1
No Major
Unemployed
39
2.82
3.05
3
0

Variable descriptions

2
1
No Major
Full Time
55
3.49
3.45
7
1

Gender = 0 (male), 1 (female)

3
1
No Major
Part Time
43
3.28
3.5
7
0

Major = student’s major

4
1
No Major
Full Time
56
3.25
3.55
7
1

Age = age of student in years

5
1
No Major
Full Time
38
3.26
3.3
6
1

MBA_GPA = overall GPA in the MBA program

6
1
No Major
Unemployed
54
2.87
3.05
4
0

BS_GPA = overall GPA in the BS program

7
1
No Major
Full Time
30
3.16
3.35
6
1

Hrs_Studying = average hours studied per week

8
1
No Major
Full Time
37
3.4
3.35
6
1

Works FT = 0 (No), 1 (Yes)

9
1
No Major
Part Time
38
2.84
3.05
3
0

10
1
No Major
Full Time
42
3.72
3.7
7
1

11
1
No Major
Part Time
52
3.22
3.5
7
0

12
1
No Major
Full Time
35
3.44
3.55
7
1

13
1
No Major
Full Time
37
3.65
3.9
8
1

14
1
No Major
Full Time
53
3.02
3.3
6
1

15
1
No Major
Part Time
51
3.03
3.25
6
0

16
1
No Major
Full Time
40
3.8
3.8
8
1

17
1
No Major
Full Time
33
3.23
3.5
7
1

18
1
No Major
Part Time
53
3.26
3.5
7
0

19
1
No Major
Full Time
43
3.53
3.75
8
1

20
1
No Major
Unemployed
35
3.75
3.9
8
0

21
1
No Major
Full Time
57
3.15
3.2
6
1

22
1
No Major
Part Time
32
3.66
3.75
8
0

23
1
No Major
Full Time
59
3.36
3.45
7
1

24
1
No Major
Full Time
48
3.79
3.85
8
1

25
1
No Major
Part Time
34
2.85
3.05
3
0

26
1
No Major
Full Time
53
3.74
3.9
8
1

27
1
No Major
Part Time
35
3.23
3.25
6
0

28
1
No Major
Unemployed
38
3.52
3.7
7
0

29
1
No Major
Part Time
37
3.32
3.45
7
0

30
1
No Major
Full Time
46
2.89
3.1
4
1

31
1
No Major
Full Time
44
2.83
3.05
3
1

32
1
No Major
Unemployed
31
2.93
3.1
5
0

33
1
No Major
Full Time
51
3.71
3.8
8
1

34
1
No Major
Full Time
47
3.47
3.75
8
1

35
1
No Major
Part Time
56
3.52
3.65
7
0

36
1
Finance
Part Time
42
2.83
3.05
3
0

37
1
Finance
Full Time
44
3.64
3.55
7
1

38
1
Finance
Unemployed
54
2.96
3.1
4
0

39
1
Finance
Full Time
51
3.59
3.8
8
1

40
1
Finance
Part Time
42
3.33
3.55
7
0

41
1
Finance
Full Time
45
3.38
3.6
7
1

42
1
Finance
Full Time
55
3.44
3.35
6
1

43
1
Finance
Full Time
47
3.31
3.45
7
1

44
1
Finance
Unemployed
43
3.03
3.25
6
0

45
1
Finance
Full Time
57
3.26
3.4
7
1

46
1
Finance
Full Time
36
3.04
3.25
6
1

47
1
Finance
Part Time
58
2.98
3.1
5
0

48
1
Finance
Full Time
46
2.8
3.05
2
1

49
1
Finance
Full Time
53
3.75
3.75
8
1

50
1
Finance
Full Time
59
3.64
3.65
7
1

51
1
Finance
Full Time
49
3.65
3.8
8
1

52
1
Finance
Full Time
34
3.18
3.3
6
1

53
1
Finance
Full Time
46
3.44
3.4
7
1

54
1
Finance
Unemployed
46
3.06
3.15
6
0

55
1
Finance
Full Time
33
3.51
3.75
8
1

56
1
Finance
Part Time
56
3.33
3.4
7
0

57
1
Finance
Full Time
39
2.81
3.05
2
1

58
1
Finance
Full Time
51
3.64
3.8
8
1

59
1
Finance
Part Time
55
3.05
3.4
7
0

60
1
Finance
Full Time
38
2.85
3.05
3
1

61
1
Marketing
Full Time
33
3.56
3.6
7
1

62
1
Marketing
Full Time
34
2.92
3.1
5
1

63
1
Marketing
Full Time
31
3.35
3.5
7
1

64
1
Marketing
Full Time
37
3.46
3.35
6
1

65
1
Marketing
Full Time
46
3.59
3.75
8
1

66
1
Marketing
Unemployed
31
3.11
3.2
6
0

67
1
Marketing
Full Time
47
3.65
3.7
8
1

68
1
Marketing
Part Time
54
3.17
3.5
7
0

69
1
Marketing
Full Time
52
2.97
3.1
5
1

70
1
Marketing
Part Time
43
3.77
3.9
8
0

71
1
Leadership
Full Time
44
3.21
3.2
6
1

72
1
Leadership
Part Time
34
3.17
3.15
6
0

73
1
Leadership
Full Time
59
3.65
3.65
7
1

74
1
Leadership
Full Time
45
2.94
3.1
5
1

75
1
Leadership
Full Time
30
3.53
3.7
8
1

76
1
Leadership
Full Time
32
3.65
3.6
7
1

77
1
Leadership
Full Time
32
3.61
3.7
8
1

78
1
Leadership
Full Time
40
3.7
3.9
8
1

79
1
Leadership
Full Time
48
2.91
3.1
5
1

80
1
Leadership
Unemployed
51
3.09
3.25
6
0

81
1
Leadership
Full Time
30
3.77
3.95
9
1

82
1
Leadership
Full Time
31
3.79
3.8
8
1

83
1
Leadership
Full Time
35
3.59
3.6
7
1

84
1
Leadership
Full Time
33
3.38
3.5
7
1

85
1
Leadership
Full Time
35
3.57
3.5
7
1

86
1
Leadership
Full Time
31
2.97
3.1
5
1

87
1
Leadership
Full Time
38
3.44
3.65
7
1

88
1
Leadership
Part Time
46
3.64
3.55
7
0

89
1
Leadership
Full Time
45
3.48
3.4
7
1

90
1
Leadership
Full Time
59
2.99
3.1
5
1

91
1
Leadership
Full Time
58
3.73
3.8
8
1

92
1
Leadership
Full Time
46
2.91
3.05
4
1

93
1
Leadership
Full Time
35
3.78
3.95
9
1

94
1
Leadership
Part Time
53
3.4
3.4
7
0

95
1
Leadership
Full Time
31
3.13
3.15
6
1

96
1
Leadership
Full Time
50
3.14
3.25
6
1

97
1
Leadership
Full Time
38
3.24
3.3
6
1

98
1
Leadership
Full Time
50
3.56
3.5
7
1

99
1
Leadership
Full Time
48
3.16
3.25
6
1

100
1
Leadership
Full Time
53
3.53
3.55
7
1

101
0
No Major
Unemployed
53
3.01
3.15
6
0

102
0
Leadership
Full Time
30
3.3
3.35
6
1

103
0
No Major
Part Time
32
3.62
3.6
7
0

104
0
Leadership
Full Time
42
3.21
3.4
7
1

105
0
Leadership
Full Time
56
3.39
3.4
7
1

106
0
No Major
Full Time
46
3.65
3.8
8
1

107
0
Leadership
Full Time
49
3.47
3.7
8
1

108
0
No Major
Part Time
32
3.44
3.6
7
0

109
0
No Major
Full Time
36
3.88
3.95
9
1

110
0
Leadership
Full Time
42
3.83
3.95
9
1

111
0
No Major
Part Time
37
3.53
3.6
7
0

112
0
No Major
Full Time
31
3.22
3.3
6
1

113
0
No Major
Full Time
31
3.56
3.8
8
1

114
0
No Major
Unemployed
42
3.2
3.25
6
0

115
0
No Major
Full Time
39
3.17
3.3
6
1

116
0
No Major
Full Time
47
3.41
3.6
7
1

117
0
No Major
Part Time
28
3.56
3.7
8
0

118
0
No Major
Unemployed
28
3.34
3.6
7
0

119
0
No Major
Full Time
52
3.44
3.6
7
1

120
0
No Major
Part Time
35
3.76
3.8
8
0

121
0
Finance
Full Time
38
3.55
3.45
7
1

122
0
Finance
Full Time
44
3.88
3.9
8
1

123
0
Finance
Part Time
38
3.31
3.45
7
0

124
0
Finance
Full Time
52
3.09
3.15
6
1

125
0
Finance
Unemployed
53
3.82
4
9
0

126
0
Finance
Part Time
53
3.01
3.2
6
0

127
0
Finance
Full Time
31
3.66
3.85
8
1

128
0
Finance
Part Time
47
3.64
3.7
8
0

129
0
Finance
Full Time
51
3.59
3.65
7
1

130
0
Finance
Unemployed
37
3.49
3.55
7
0

131
0
Finance
Part Time
46
3.13
3.2
6
0

132
0
Finance
Full Time
48
3.83
3.9
8
1

133
0
Finance
Full Time
54
3.04
3.15
6
1

134
0
Finance
Full Time
48
3.91
4
10
1

135
0
Finance
Full Time
36
3.56
3.7
8
1

136
0
Finance
Unemployed
39
3.96
4
9
0

137
0
Finance
Full Time
28
3.46
3.4
7
1

138
0
Finance
Part Time
45
3.22
3.15
6
0

139
0
Finance
Full Time
31
3.27
3.2
6
1

140
0
Finance
Full Time
47
3.43
3.45
7
1

141
0
Finance
Part Time
35
3.85
3.95
9
0

142
0
Finance
Full Time
52
3.89
3.9
8
1

143
0
Finance
Part Time
52
3.37
3.45
7
0

144
0
Finance
Unemployed
55
3.32
3.3
6
0

145
0
Finance
Full Time
52
3.54
3.55
7
1

146
0
Finance
Part Time
46
3.8
3.9
8
0

147
0
Finance
Full Time
31
3.74
3.85
8
1

148
0
Finance
Full Time
33
3.17
3.45
7
1

149
0
Finance
Part Time
45
3.27
3.55
7
0

150
0
Finance
Full Time
50
3.32
3.3
6
1

151
0
Marketing
Part Time
33
3.56
3.45
7
0

152
0
Marketing
Full Time
37
3.95
4
9
1

153
0
Marketing
Unemployed
33
3.56
3.75
8
0

154
0
Marketing
Full Time
46
3.79
3.75
8
1

155
0
Marketing
Part Time
55
3.93
4
9
0

156
0
Marketing
Full Time
30
3.79
3.85
8
1

157
0
Marketing
Full Time
51
3.71
3.85
8
1

158
0
Marketing
Part Time
35
3.05
3.35
6
0

159
0
Marketing
Unemployed
40
3.22
3.2
6
0

160
0
Marketing
Part Time
29
3.85
3.95
9
0

161
0
Marketing
Full Time
52
3.82
3.95
9
1

162
0
Marketing
Full Time
27
3.23
3.95
9
1

163
0
Marketing
Full Time
51
3.56
3.65
7
1

164
0
Marketing
Part Time
56
3.53
3.65
7
0

165
0
Marketing
Full Time
35
3.62
4
9
1

166
0
Leadership
Full Time
46
3.8
3.95
9
1

167
0
Leadership
Part Time
39
3.47
3.35
6
0

168
0
Leadership
Full Time
31
3.64
3.65
7
1

169
0
Leadership
Full Time
52
3.03
3.15
5
1

170
0
Leadership
Unemployed
32
3.17
3.25
6
0

171
0
Leadership
Part Time
32
3.22
3.2
6
0

172
0
Leadership
Full Time
44
3.92
4
10
1

173
0
Leadership
Full Time
43
3.82
3.95
9
1

174
0
Leadership
Part Time
38
3.26
3.55
7
0

175
0
Leadership
Full Time
54
3.8
3.85
8
1

176
0
Leadership
Full Time
27
3.2
3.2
6
1

177
0
Leadership
Part Time
38
3.46
3.35
6
0

178
0
Leadership
Full Time
45
3.67
3.75
8
1

179
0
Leadership
Unemployed
48
3.06
3.4
7
0

180
0
Leadership
Full Time
43
3.66
3.85
8
1

181
0
Leadership
Full Time
34
3.96
4
10
1

182
0
Leadership
Full Time
54
3.75
3.85
8
1

183
0
Leadership
Full Time
36
3.83
3.85
8
1

184
0
Leadership
Full Time
45
3.22
3.2
6
1

185
0
Leadership
Unemployed
28
3.36
3.35
6
0

186
0
Leadership
Full Time
37
3.21
3.25
6
1

187
0
Leadership
Full Time
27
3.02
3.15
5
1

188
0
Leadership
Full Time
31
3.99
4
10
1

189
0
Leadership
Unemployed
45
3.07
3.15
6
0

190
0
Leadership
Full Time
48
3.65
3.65
7
1

191
0
Leadership
Full Time
50
3.67
3.85
8
1

192
0
Leadership
Full Time
32
3.06
3.35
6
1

193
0
Leadership
Unemployed
33
3.98
3.7
8
0

194
0
Leadership
Full Time
49
3.93
4
10
1

195
0
Leadership
Unemployed
27
3.41
3.3
6
0

196
0
Leadership
Part Time
28
3.43
3.5
7
0

197
0
Leadership
Full Time
36
3.7
3.65
7
1

198
0
Leadership
Full Time
35
3.76
3.75
8
1

199
0
Leadership
Part Time
47
3.9
3.9
8
0

200
0
Leadership
Full Time
33
3.23
3.3
6
1

SHOW MORE…

Week 7 UTI

Focused SOAP Note Template

Patient Information:

Initials, Age, Sex, Race

S
(subjective)

CC (chief complaint): a BRIEF statement identifying why the patient is here, stated in the patients own words (for instance “headache,” NOT “bad headache for 3 days).

HPI (history of present illness): This is the symptom analysis section of your note. Thorough documentation in this section is essential for patient care, coding, and billing analysis. Paint a picture of what is wrong with the patient. Use LOCATES Mnemonic to complete your HPI. You need to start EVERY HPI with age, race, and gender (e.g., 34-year-old AA male). You must include the seven attributes of each principal symptom in paragraph form not a list. If the CC was headache, the LOCATES for the HPI might look like the following example:

Location: Head
Onset: 3 days ago
Character: Pounding, pressure around the eyes and temples
Associated signs and symptoms: Nausea, vomiting, photophobia, phonophobia
Timing: After being on the computer all day at work
Exacerbating/relieving factors: Light bothers eyes; Aleve makes it tolerable but not completely better
Severity: 7/10 pain scale

Current Medications: Include dosage, frequency, length of time used, and reason for use; also include over the counter (OTC) or homeopathic products.

Allergies: Include medication, food, and environmental allergies separately, including a description of what the allergy is (i.e., angioedema, anaphylaxis, etc.). This will help determine a true reaction versus intolerance.

PMHx: Include immunization status (note date of
last tetanus for all adults), past major illnesses, and surgeries. Depending on the CC, more info is sometimes needed.

Soc and Substance Hx: Include occupation and major hobbies, family status, tobacco and alcohol use (previous and current use), and any other pertinent data. Always add some health promo question here, such as whether they use seat belts all the time or whether they have working smoke detectors in the house, living environment, text/cell phone use while driving, and support system.

Fam Hx: Illnesses with possible genetic predisposition, contagious, or chronic illnesses. Reason for death of any deceased first-degree relatives should be included. Include parents, grandparents, siblings, and children. Include grandchildren if pertinent.

Surgical Hx: Prior surgical procedures.

Mental Hx: Diagnosis and treatment. Current concerns (anxiety and/or depression). History of self-harm practices and/or suicidal or homicidal ideation.

Violence Hx: Concern or issues about safety (personal, home, community, sexual (current and historical).

Reproductive Hx: Menstrual history (date of LMP), Pregnant (yes or no), Nursing/lactating (yes or no), contraceptive use (method used), types of intercourse (oral, anal, vaginal, other, any sexual concerns).

ROS (review of symptoms): Cover all body systems that may help you include or rule out a differential diagnosis You should list each system as follows:

General:

Head:

EENT (eyes, ears, nose, and throat):

Etc.:

Note: You should list these in bullet format, and document the systems in order from head to toe.

Example of Complete ROS:

GENERAL:No weight loss, fever, chills, weakness, or fatigue.
HEENT:
Eyes: No visual loss, blurred vision, double vision or yellow sclerae.
Ears, Nose, Throat: No hearing loss, sneezing, congestion, runny nose, or sore throat.
SKIN: No rash or itching.
CARDIOVASCULAR: No chest pain, chest pressure or chest discomfort. No palpitations or edema.
RESPIRATORY: No shortness of breath, cough or sputum.
GASTROINTESTINAL: No anorexia, nausea, vomiting or diarrhea. No abdominal pain or blood.
GENITOURINARY: Burning on urination. Last menstrual period (LMP), MM/DD/YYYY.
NEUROLOGICAL: No headache, dizziness, syncope, paralysis, ataxia, numbness or tingling in the extremities. No change in bowel or bladder control.
MUSCULOSKELETAL: No muscle, back pain, joint pain or stiffness.
HEMATOLOGIC: No anemia, bleeding or bruising.
LYMPHATICS: No enlarged nodes. No history of splenectomy.
PSYCHIATRIC: No history of depression or anxiety.
ENDOCRINOLOGIC: No reports of sweating, cold or heat intolerance. No polyuria or polydipsia.
REPRODUCTIVE: Not pregnant and no recent pregnancy. No reports of vaginal or penile discharge. Not sexually active.
ALLERGIES: No history of asthma, hives, eczema or rhinitis.

O
(objective)

Physical exam: From head-to-toe, include
what you see, hear, and feel when doing your physical exam. You only need to examine the systems that are pertinent to the CC, HPI, and History.
Do not use WNL or normal. You must describe what you see. Always document in head to toe format (i.e., General: Head: EENT: etc.).

Diagnostic results: Include any labs, x-rays, or other diagnostics that are needed to develop the differential diagnoses (support with evidenced and guidelines).

A
(assessment)

Differential diagnoses: List a minimum of three differential diagnoses. Your primary or presumptive diagnosis should be at the top of the list. For each diagnosis, provide supportive documentation with evidence-based guidelines.

P
(plan)

Includes documentation of diagnostic studies that will be obtained, referrals to other health-care providers, therapeutic interventions, education, disposition of the patient, and any planned follow up visits. Each diagnosis or condition documented in the assessment should be addressed in the plan. The details of the plan should follow an orderly manner.

Also included in this section is the reflection. Reflect on this case, and discuss what you learned, including any aha moments or connections you made.

Also include in your reflection, a discussion related to health promotion and disease prevention taking into consideration patient factors (such as, age, ethnic group, etc.), PMH, and other risk factors (e.g., socio-economic, cultural background, etc.).

References

You are required to include at least three evidence-based peer-reviewed journal articles or evidenced-based guidelines, which relate to this case to support your diagnostics and differentials diagnoses. Be sure to use correct APA 7th edition formatting.

2020 Walden University 1 Review the case study provided by your Instructor.
Reflect on the patients symptoms and aspects of disorders that may be present.
Consider how you might assess, perform diagnostic tests, and recommend medications to treat patients presenting with the symptoms in the case.
Access the Focused SOAP Note Template in this weeks Resources.

The Assignment:

Complete the Focused SOAP Note Template provided for the patient in the case study. Be sure to address the following:
Subjective: What was the patients subjective complaint? What details did the patient provide regarding their history of present illness and personal and medical history? Include a list of prescription and over-the-counter drugs the patient is currently taking. Compare this list to the American Geriatrics Society Beers Criteria, and consider alternative drugs if appropriate.Provide a review of systems.
Objective: What observations did you note from the physical assessment? What were the lab, imaging, or functional assessments results?
Assessment: Provide a minimum of three differential diagnoses. List them from top priority to least priority.Compare the diagnostic criteria for each, and explain what rules each differential in or out. Explain you critical thinking process that led you to the primary diagnosis you selected. Include pertinent positives and pertinent negatives for the specific patient case.
Plan: Provide a detailed treatment plan for the patient that addresses each diagnosis, as applicable. Include documentation of diagnostic studies that will be obtained, referrals to other health-care providers, therapeutic interventions, education, disposition of the patient, caregiver support, and any planned follow-up visits. Provide a discussion of health promotion and disease prevention for the patient, taking into consideration patient factors, past medical history (PMH), and other risk factors. Finally, include a reflection statement on the case that describes insights or lessons learned.
Provide at least three evidence-based peer-reviewed journal articles or evidenced-based guidelines, which relate to this case to support your diagnostics and differentials diagnoses. Be sure they are current (no more than 5 years old) and support the treatment plan in following current standards of care. Follow APA 7th edition formatting.

Week 7

Case Study 1:

R.B. 95-year-old, white male, currently living in a skilled nursing facility (SNF)

Chief complaint:My urine is really red.

HPI:On Wednesday (2 days ago) the patient was brought to your clinic by his son and complained that his urine appeared to be bright red in color. You ordered labs, urinalysis, culture, and sensitivity, and the results are below.

Allergies:Penicillin: Hives

Medications: Tamsulosin 0.4 mcg, 2 capsules daily, Aspirin 325 mg daily, Atorvastatin 10 mg 1 tablet daily, Donepezil 10 mg 1 tablet PO QHS, Metoprolol 25 mg 0.5 mg tablet every 12 hours, Acetaminophen 500 mg 1 tablet BID

Code status:DNR Regular diet, pureed texture, honey-thickened liquids

Vitals:BP 122/70, HR 66, Temp 98.0 F, Resp 18, Pulse ox 98%

PMH:Cognitive communication deficit, pneumonitis due to inhalation of food and vomit, dysphagia, R-side hemiplegia and hemiparesis past ischemic CVA, moderate vascular dementia, malignant neoplasm of prostate, new-onset atrial fibrillation (12/2019), DVT on left lower extremity, gross hematuria

Labs:

RBC 3.53 (L)
Hemoglobin 10.2 (L)

Microscopic Analysis, Urine, straight cath

Component:

WBC UA 42 (H) (0-5/ HPF)

RBC, UA >900 (H) (0-5/HPF)
Epithelial cells, urine 2 (0-4 /HPF)
Hyaline casts, UA 0 (0-2 /LPF)

Urinalysis

Color Red
Appearance (Urine) Clear
Ketones, UA Trace
Specific gravity 1.020 (1.005-1.025)
Blood, UA Large
PH, Urine 7.0 (5.0-8.0)
Leukocytes Small

Nitrites Positive

C&S results were not available yet.