Mat 144 Major Assignment 2

Description

Answer directly on the worksheet. This assignment uses a scoring guide. Review the scoring guide on the first tab of the spreadsheet prior to beginning the assignment to become familiar with the expectations for successful completion. Delight note that the Confidence Interval Explanation certificate is provided for reference and assistance with Major Assignment 2.

Also, avoid plagiarism!

Unformatted Attachment Preview

Hither is ane sample from the earlier data. Hit to get a new Samples from the after data sample. mean is found. This is repeat distribution. The normal dist Before the mean of the after information a 25 standard deviation of the aft 20 root of the number of sampl groundwork. The 95% confide fifteen red coloring on the normal di 10 mean + 1.96*SE). The meanin 5 the sampling distribution sho >100 100 95 90 85 80 75 70 65 60 55 fifty 45 40 35 30 25 twenty 15 10 5 0 0 Here is one sample from the later data. Hitting to become a new sample. After 25 xx 1000 mean counts 0.18 0.16 0.14 0.12 0.1 0.08 0.06 0.04 0.02 0 15 x Hateful of samplin Standard Divergence of v 100 >100 95 xc 85 fourscore 75 70 65 lx 55 50 45 twoscore 35 30 25 20 15 ten 5 0 0 Here is another perspective. 100 samples were fatigued from the Afterward Data. A 95% CI expect 95% of these CI'south to comprise the true population mean. Hit to regenerate. 100 CI's computed from Samples of size 100 from the Later on D 72 67 62 57 52 1 iii 5 seven nine 11 13 15 17 xix 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49 51 53 55 57 59 52 1 three 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49 51 53 55 57 59 Population Mean %CI's that comprise the mean: 94% Each CI is formed by finding the me standard deviation of the sample (S of samples). The CI is computed as ( A good intuition for the CI: The mean is a point guess. You accept a sample of the population, as an estimate for the population mean. Why should this gauge be whatever good, after all, you just is an interval estimate, a 95% CI is an interval obtained from a sample and you interpret this every bit: population mean is in the interval." You are not predicting a specific hateful for the population, inst possible values for the population mean and you are able to quantify how certain y'all are that the that interval. Samples from the after data of size 100 are taken and the mean is found. This is repeated 1000 times to become a sampling distribution. The normal distribution which has mean equal to the mean of the after data and standard deviation equal to the standard deviation of the after information divided by the foursquare root of the number of samples, this is the SE, is shown in the groundwork. The 95% confidence interval is indicated past the red coloring on the normal distribution, this is (mean - 1.96*SE, mean + 1.96*SE). The meaning should exist clear, about 95% of the sampling distribution should occur in this interval. yard mean counts for samples of size 100 Mean of sampling distribution: 66.02 Standard Divergence of Sampling Dist: ii.288296504 m the Afterwards Data. A 95% CI was created for each. We should mean. Hitting to regenerate. f size 100 from the Afterwards Information 59 61 63 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 59 61 63 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 I is formed by finding the mean (M) of the sample and then the rd deviation of the sample (SD). SE is computed as SD/sqrt(# ples). The CI is computed every bit (M - 1.96*SE, M + 1.96*SE) e a sample of the population, take the sample mean and apply this exist any adept, afterwards all, you just have one random sample. The CI ple and you interpret this as: "I am 95% certain that the actual c hateful for the population, instead y'all are finding an interval of y how certain you are that the true population mean is inside Part 1 Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be rec Possible points Points earned Five year inflation rate x Projection of expenses in Major Assignment ane 10 Part one total 20 0 Part 2 Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be rec Possible points Points earned Descriptive Statistics 16 Interpret Descriptive Statistics 14 Proportion calculations 10 Interpretation of proportions 10 Conversions ten Improvement level data set v Descriptive Statistics for comeback levels x Histogram five Standard mistake of the mean 5 Confidence interval 10 Discussion of the placement of 0 10 Role 2 total 105 0 Total of Worksheet 2 125 0 one h cell references. Answers must be recorded on the worksheet. Comments two h cell references. Answers must be recorded on the worksheet. Comments 0% Input your proper name below: Full Name Proper noun! Unadjusted CPI, all items for v years ago Unadjusted CPI, all items for final month What is the 5 year aggrandizement charge per unit, that is percentage increase in your CPI values? If something toll $ane.00 five years agone, what would it cost at present? Total budget from Major Assignment 1 five year projected budget total Color Cardinal: formula text/number Calendar month Year CPI number number Y'all should just utilize the budget information CPI values, here are the instructions: Stride 1: Get to the Bureau of Labor Statistics westward Step 2: Cheque the box next to "U.S. metropolis aver Step iii: Click "Recall Data" formula Use the virtually recent CPI value and the CPI fo before to compute the 5 year inflation charge per unit. formula the cost of your trip five years from now. number CPI Data Link formula Like Topic 4 DQ 1 just utilize the upkeep information from Major Assignment i. For the hither are the instructions: to the Bureau of Labor Statistics website at the link below. eck the box adjacent to "U.South. city average, All items - CUUR0000SA0" k "Retrieve Information" ost recent CPI value and the CPI for the same calendar month but five years ompute the five year inflation rate. Use this inflation rate to estimate f your trip v years from now. CPI Information Link Enter your name in cell A2 of "Office 1 - Inflation" to generate information. Before wells were dug Eastward.Coli per ml Data Data Data Data Data Data Data Data Data Data Data Data Information Information Data Data Data Data Data Data Information Data Information Data Data Data Data Data Information Data Data Information Data Information Data Data Data Information After wells were dug E.Coli per ml Data Data Data Information Data Information Information Data Data Data Data Data Information Information Data Information Data Data Data Data Data Data Information Data Data Data Information Data Data Data Data Data Data Data Data Data Data Data YOUR NAME: From Part ane A1 Full Name Earlier min = formula max = formula hateful= formula SD = formula # of wells tested = formula # of wells with 0 Due east coli = formula Ratio Percentage Clean Conversions ml 29.5735 In 24 ounces E.coli earlier formula Data Data Data Information Data Data Data Data Information Information Data Data Data Information Information Data Data Information Data Data Data Data Information Data Information Data Data Data Data Data Data Information Data Data Data Information Information Information Information Data Data Data Data Data Data Data Data Data Information Data Data Data Data Data Data Information Information Data Information Data Data Information Data Data Data Data Data Data Data Information Data Data Data Information Information Data Data Data Data Data Information Data Data Data Data Data Information Data Information Data Data Information Data Information Data Data Information Data Data Data Data Data Data Data Information Information Data Data Data Information Data Data Information Data Data Information Data Data Data Data Data Data Data Data Data Data Data Data Information Data Data Data Data Data Information Data Information Information Data Data Data Data Information Data Information Data Data Data Data Data Data Information Data Information Data Data Data Data Function two – Information Analysis: Enter your proper noun in cell A2 of "Part i - Infla You take simply completed a mission to Sierra quality of water in the wells in a certain reg well before and after your mission. You nee for that you need to perform some statistic from dissimilar perspectives to make up one's mind if A2 of "Part one - Inflation" to ate data. After min = max = mean= SD = # of wells tested = # of wells with 0 E coli = Earlier formula versions formula formula formula formula formula formula Recall Topic ane DQ 2 Afterward formula 1. Summate descriptive statistics for your da the statistics including mean, max and stan there has been improvement in water quali statistics to obtain full marks. (Fill in the be descriptive statistics. The information has been nam formulas.) Reply Question i below: Color Fundamental: oz 1 4 ounces East. coli afterwards formula formula text/number 2. The water quality is "skilful" if the count o Calculate the proportion of wells with "goo measure does it announced that the quality of you calculated. (In G11 and H11 calculate thursday Answer Question 2 below: 3. Expect at well #1 (B2 and C2) in your data. ingest if y'all drank from the well before the how many Eastward.coli would you lot ingest if y'all dra after the mission.) Zero to reply here! ata Analysis: r name in prison cell A2 of "Part 1 - Aggrandizement" to generate data. ust completed a mission to Sierra Leone. The goal of the mission was to improve the water in the wells in a certain region. You nerveless data on the Eastward. coli count from each e and after your mission. You need to write a report on the success of the mission and ou need to perform some statistical analysis on the data. You will be looking at the data rent perspectives to decide if the water quality has improve. e descriptive statistics for your data in the tabular array provided in the Excel spreadsheet. Utilize ics including mean, max and standard deviations of the data to determine if it appears if been improvement in water quality? This requires a thorough discussion of these o obtain full marks. (Fill up in the before (F3:F8) and afterwards (H3:H8) tables to the left for the e statistics. The information has been named before and later on for your convenience in creating nswer Question ane below: er quality is "good" if the count of E coli is 0; otherwise, the water quality is still bad. the proportion of wells with "good" water to wells whose h2o is not good. From this does it appear that the quality of h2o improved? Explain and use the proportions that ated. (In G11 and H11 calculate the percent Make clean for before and after.) nswer Question 2 below: well #ane (B2 and C2) in your data. If y'all drank 24oz of water how many East.coli would you ou drank from the well earlier the mission? Afterwards the mission? (In E20 and G20 calculate E.coli would y'all ingest if you drank 24 oz. of h2o from Well 1 earlier the mission and mission.) Cipher to answer here! Original Earlier Data 78 nineteen 32 125 53 68 4 106 38 36 4 17 43 23 32 49 36 2 33 58 75 82 80 70 79 73 76 72 72 70 84 81 69 85 100 70 74 Original After Data 67 4 23 110 41 42 10 79 6 16 14 5 9 3 8 28 eighteen 21 22 25 59 63 60 52 l 66 54 42 55 53 54 62 59 52 69 57 45 63 76 78 87 71 83 71 75 76 63 70 65 83 76 78 76 68 77 75 67 74 86 85 72 73 59 72 64 67 79 64 86 74 83 81 70 71 68 76 72 71 86 86 88 78 73 84 39 60 75 64 41 67 56 57 58 39 38 l 59 48 59 49 47 51 58 53 45 58 67 48 65 43 55 25 48 55 33 65 53 61 55 47 54 54 64 55 55 77 62 67 59 45 57 78 77 88 83 70 65 74 73 79 87 79 77 66 73 85 77 53 57 68 61 32 48 52 53 58 59 57 55 52 58 63 55 Enter your proper noun in cell A2 of "Part one - Inflation" to generate data. Before wells were dug East.Coli per ml Information Data Data Data Data Data Data Information Data Data Data After wells were dug East.Coli per ml Data Data Information Information Data Information Data Data Information Data Data Data Data Information Data Data Data Data Information Data Data Information Data Data Data Data Data Data Data Data Data Information Information Data Data Information Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Information Data Data Data Information Data Data Data Information Information Data Information Comeback Information: Before - After All computations apply column D, the "Comeback" data. min = formula max = formula mean= formula SD = formula count = formula SE = formula Histogram - Width Bin Width formula Frequency Distribution Depression formula formula formula formula formula formula formula formula formula formula formula High Bins formula auto formula auto formula auto formula machine formula auto formula auto formula motorcar formula motorcar formula auto formula auto formula automobile Remember to create the Histogram. 95% Conviction Interval Lower number to Higher number formula to formula Data Data Data Information Data Data Information Information Data Data Data Data Data Data Data Data Data Information Data Data Data Data Data Data Data Data Data Data Data Data Data Data Data Information Data Data Information Data Data Data Data Data Data Data Data Data Information Information Information Data Data Information Information Data Information Data Information Information Data Data Data Data Information Information Information Data Data Data Data Data Data Information Data Data Data Data Information Data Information Data Information Data Data Data Data Data Information Data Information Information Data Data Data Information Information Data Information Information Information Data Data Data Information Data Information Data Information Data Information Data Data Data Data Data Data Information Information Data Data Information Data Data Data Information Information Information Data Data Data Information Data Data Information Data Data Information Data Information Data Information Data Data Data Information Data Information Data Data Data Information Information Data Information Data Information Data Information Data Data Data Part ii – Data Analysis: Y'all have merely completed a mission to Sierra Leone. The goal of the mission was wells in a certain region. You collected data on the Due east. coli count from a sample mission. Y'all need to write a report on the success of the mission and for that y statistical analysis on the data. You will be looking at the data from unlike pe water quality has improved. Colour Key: formula text/number ncy Distribution Cumulative Frequency formula formula formula formula formula formula formula formula formula formula formula create the Histogram. 4. Since you collected h2o from the same source twice it makes sense to ana well'southward water quality improved. Calculate a data set that would measure the ch each well, and the descriptive statistics for that data set, including both the south error (SE) for the data set. (see section 3.5 of the textbook and the boosted E with this major consignment). Make a frequency distribution and histogram for comeback in the water quality of each well in cavalcade D. (Difference in Lev tables to the left and make a histogram of the improvement levels. (NOTE: The is non the same as the standard fault. Use the formulas from section 3.5 of the fault of the ways.)) Frequency formula formula formula formula formula formula formula formula formula formula formula five. You have calculated one sample of wells and their improvement levels. If yo wells of the, the distribution of all of those sample means would exist a normal d the 95% confidence interval of that distribution, using your sample hateful as t standard error of your sample every bit the population standard deviation. (Calcula the sampling distribution in cells F30 and H30.) half-dozen. Think that a 95% confidence interval shows a range of values that is 95% like your 95% conviction interval for the boilerplate improvement level is (14, xviii), it w likely to be in the range (14, 18). (Come across the additional Excel document provided a Histogra At present answer each of these questions: a) Wait at the mean for your improvement information, based on this what would you wells. b) Look at the confidence interval you calculated--is the value 0 inside or outsid c) If the value 0 is exterior and less than your 95% confidence interval, can you cleaner? d) What if the value 0 were within your confidence interval? Could you conclud Answer Question half-dozen (a): Answer Quastion 6 (b): Reply Question half-dozen (c): Reply Question 6 (d): eone. The goal of the mission was to meliorate the quality of water in n the Due east. coli count from a sample of wells before and later your ccess of the mission and for that you need to perform some king at the data from different perspectives to decide if the ource twice it makes sense to analyze the corporeality past which each ta fix that would measure the modify in the number of Due east. coli in hat data prepare, including both the standard divergence and standard the textbook and the additional Excel certificate provided along cy distribution and histogram for your data. (Summate the ell in column D. (Difference in Level of east. Coli.) And then, fill out the ii e improvement levels. (Notation: The Standard deviation of this information prepare e formulas from section three.v of the text to calculate the standard nd their improvement levels. If you could take all possible samples of mple means would exist a normal distribution. (see section three.5). Find ion, using your sample hateful every bit the population mean and the tion standard deviation. (Calculate the 95% confidence interval of 0.) s a range of values that is 95% likely to contain the true value of a parameter. For example, if improvement level is (14, 18), information technology would hateful that the true boilerplate improvement level is 95% itional Excel document provided along with this major assignment for more details.) ata, based on this what would you say nigh the change in the quality of h2o in the tested ted--is the value 0 within or outside your conviction interval? 95% confidence interval, can you lot conclude (with 95% confidence) that the water became ence interval? Could you conclude (with 95% confidence) that the water became cleaner?
Buy reply to see full attachment

User generated content is uploaded by users for the purposes of learning and should exist used post-obit Studypool'due south honor code & terms of service.

Hi,PFA the solution..Thanks!

Part 1
Requirements: Answer each question fully. Utilize Excel formulas with prison cell references. Answers must be rec
Possible points
Points earned
Five year aggrandizement rate
10
Projection of expenses in Major Assignment 1
10
Part 1 full
20
0
Function ii
Requirements: Reply each question fully. Utilise Excel formulas with prison cell references. Answers must be rec
Possible points
Points earned
Descriptive Statistics
16
Interpret Descriptive Statistics
14
Proportion calculations
10
Interpretation of proportions
10
Conversions
10
Improvement level information set
5
Descriptive Statistics for comeback levels
x
Histogram
5
Standard error of the mean
5
Confidence interval
10
Discussion of the placement of 0
10
Office 2 total
105
0
Full of Worksheet 2
125
0

one
h cell references. Answers must be recorded on the worksheet.
Comments

2
h cell references. Answers must exist recorded on the worksheet.
Comments

Input your name below:
Serena Greyness

Proper name!
Unadjusted CPI, all items for 5 years ago
Unadjusted CPI, all items for final month
What is the 5 year inflation rate, that is
percent increase in your CPI values?
If something toll $1.00 v years ago, what
would it cost at present?
Total budget from Major Assignment 1
v twelvemonth projected budget total

Colour Cardinal:

formula
text/number
Month
July
July

Year

CPI
You lot should just use the upkeep data
2015 238.654 CPI values, hither are the instructions:
2020 259.101 Stride one: Go to the Bureau of Labor Statistics w
Step 2: Check the box next to "U.S. urban center aver
Step 3: Click "Recollect Data"
9%
Use the most contempo CPI value and the CPI fo
earlier to compute the v year aggrandizement rate.
$1.09
the cost of your trip v years from now.
$five,723.fourteen
CPI Information Link
$6,213.48

Like Topic 4 DQ 1

just use the upkeep information from Major Consignment 1. For the
hither are the instructions:
to the Bureau of Labor Statistics website at the link beneath.
eck the box side by side to "U.S. city average, All items - CUUR0000SA0"
k "Remember Data"
ost recent CPI value and the CPI for the same month but five years
ompute the 5 twelvemonth inflation rate. Use this inflation rate to estimate
f your trip v years from at present.
CPI Data Link

Enter your proper noun in cell A2 of "Part 1 - Inflation" to
generate data.
Earlier wells Afterwards wells
were dug
were dug
E.Coli per ml E.Coli per ml
eleven
17
37
one
7
25
26
26
30
0
22
0
17
15
27
17
17
23
36
0
eight
34
thirty
xiii
28
13
24
9
21
10
23
xix
36
0
15
15
17
13
31
forty
39
twenty
25
eighteen
36
48
53
vii
fifteen
6
25
eleven
12
22
27
32
35
3
22
16
32
38
43
27
26
11
31
35
43
3
xi
17
20
0
8
29

YOUR Proper name:
From Function ane A1

Serena Grayness

Earlier
min = 1
max = 53
mean= 24.25641026
SD = 10.71830037
# of wells tested = 117
# of wells with 0 E coli = 0
Ratio
Percent Make clean
Conversions
ml
29.5735
In 24 ounces
E.coli earlier
7807.404

forty
36
17
26
23
3
29
21
16
11
41
47
iv...

Studypool

4.7

Trustpilot

4.5

Sitejabber

4.4

Financial and Operational Risk Assessment

This is the showtime step in developing a take a chance assessment and management policy. In developing your policy, consideration of ...

Fiscal and Operational Risk Assessment

This is the showtime step in developing a hazard cess and management policy. In developing your policy, consideration of hazard ambition is critical. Place the areas of financial and operational risk at CCH. Prepare a policy on how each area of risk should be handled (i.e presume the risk, mitigate the risk, or transfer the adventure).Prepare a table with the risks that you lot have identified, level of take a chance, strategy, and justification for choosing the strategy. You lot are encouraged to use the balance sheet and income statement equally a starting point, but proceed in mind there are items not listed on the financials that tin can also be at hazard. For instance, the reputation of the company, HIPAA, or key employees. Below is a suggested format only feel complimentary to add together boosted columns equally needed.Adventure AreaLevel of RiskStrategy (Assume, Mitigate, Transfer)CashLowAssume cash consists of bank deposits federally insuredVehiclesMediumAssume concrete damage, transfer liability risk

Case of Global Ethics vs. Global Economy

Case of Global Ideals vs. Global Economy This is a case that will be tried in the courtroom of Public Opinion.Skillful Clothes Com ...

Case of Global Ethics vs. Global Economy

Case of Global Ethics vs. Global Economy This is a case that will be tried in the courtroom of Public Stance.Good Dress Company, a United States corporation, buys wear assembled past Beta, LTD., a foreign company that employs immature children for long hours and low pay. Beta's nation does not enforce its child labor laws. Beta and Good Apparel are aware of this.Homo International Politics (HIP), an international political activist organization, discovered Good Apparel' connection to Beta, LTD. HIP plans to reveal this information to the press and on social media. Good Clothes hears about this proposed action by HIP. Before HIP can act, Good Clothes terminates its human relationship with Beta. Expert Clothes then publicizes this activity in its advertising. The company's sales and profits increase, apparently as a directly result.Has Skillful Clothes acted unethically in any way(s)? Explain using one of the ethical philosophies from the text and facts from the scenario.From an ethical perspective, is Good Clothes' acquit in terminating its human relationship with Beta more of import than whatsoever its motive might be? Why or why not?