# Scatter graph, statistics assignment help

all i need help with is questions 1 and 3 in the excel file posted below. if  you have any ?’s please ask me asap
econ_take_home_portion_of_test_3.xlsx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Scatter graph, statistics assignment help
Just from \$10/Page

take-home problems for Test #3
Take-home problems for Test #3
>> Neither give nor receive assistance on these problems.
>> A one-page printout of this worksheet–with your name handwritten on the upper right–is due at the beginning of class on
Friday, April 29. Your Excel file is due in the Dropbox titled Take-home portion of Test 3 by the beginning of that class.
1.[7] Below, for a sample of 20 production runs for making a particular replacement part for refrigerators, are given:
X = the lot size (number of parts made in the run) and Y = labor hours (total labor hours to complete the run)
Lot Size
399
121
221
376
361
224
546
352
353
157
160
252
389
113
435
420
212
268
377
421
Labor Hours
80
30
50
90
70
60
120
80
100
50
40
70
90
20
110
100
20
50
90
110
(a) Create a scatter diagram of the 20 data points, being sure to provide axis titles/labels.
Superimpose on the scatter diagram the best-fitting line.
(b) Use an Excel statistical function to determine the
correlation (coefficient) between lot size and labor hours (and keep the
cell formatted to 4 decimal places).
2.[12] Locate the requested data at the indicated website, and associate a unit with each answer.
(a) www.bea.gov
In 2015, what was the Gross Domestic Product of the U.S.?
(b) www.census.gov
In 2014, in Cherokee County, Georgia, what estimated percentage of workers 16 years and over
drove alone to work via car, truck, or van?
(c) www.stlouisfed.org
What was the price of one barrel of crude oil of the West Texas Intermediate variety
on April 11, 2016? Note: Crude oil is considered a commodity.
(d) www.worldbank.org
In 2015, what percentage of the land area of the United States was forest area?
3.[5] After working the problem on the next worksheet (named “third problem”), copy–AS A PICTURE–your work to the box below.
Page 1
An employee in the Department of Health and Human Services conducted a study to compare the mean daily fa
grams) of children in low-income households to that of children in high-income households. Below are the daily
of independent random samples of 50 children from low-income households and 50 children from high
respectively. With μlow-inc designating the mean daily fat intake of children in low-income households and
fat intake of children in high-income households:
(a) Use Excel to test H0: μlow-inc – μhigh-inc ≤ 25
Low-inc High-inc
60
49
59
67
69
62
78
55
64
63
62
63
65
59
55
59
62
66
63
59
81
69
70
62
63
49
64
68
72
60
72
67
59
58
55
72
79
59
64
71
78
68
31
37
37
32
30
29
33
32
30
41
32
29
32
34
29
34
44
35
33
37
37
40
32
38
36
38
31
39
34
34
37
28
39
33
35
32
28
38
36
36
33
35
68
74
73
49
64
65
62
56
33
32
37
37
36
40
31
35
mpare the mean daily fat intake (in
ds. Below are the daily fat intake levels
ren from high-income households,
households and μhigh-inc the mean daily

attachment

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.