Scatter graph, statistics assignment help

User Generated

xfhtenq2018

Mathematics

Description

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

Unformatted Attachment Preview

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. >> Place all your answers in the boxes provided. 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
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Sorry I was not able to respond to you in good time.It rained heavily and power cable were interrupted in the whole city but everything have been restored and I was able to finish on your assignment.Kindly go through it and if some changes or modifications are required please I'M here for that.Attached is the excel sheet with the answersKind regards 

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-h...


Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags