A sample of students was taken measuring the hours studied for a test

2- A sample of students was taken measuring the hours studied for a test and the score on the test (out of a possible total of 350 points) X(# hours study) Y (Score on test) 5 155 7 210 8 150 10 192 11 245 13 260 15 270 18 275 20 290a). Give the following:i) sum of the xii) sum of the yiii) sum of the x squarediv) sum of the xyv) sum of the y squaredb) Find b sub 0 and b sub 1 using the formulas in Excel that were used in the module. Round to 3 decimal places.c) Find the equation of the regression line.d) What is the value of the slope and interpret its meaning in the context of this probleme) Predict the test score for 13 hours of study.f) Calculate the coefficient of determination by writing the formula in Excel. Show your calculations.g) What % of the variation in test scores is explained by the # hours of study?h) What % is due to other factors?i) Name 1 other factor that could affect a test score.j) What is the calculated F in testing the null hyothesis: no significant relation between # hours of study and test scores. (You must use the Tool-Pak for this.)k) What is the p-value?l) Is there a significant relation between #hours of study and test scores? Please answer yes or no3- The following data give the sales in millions of dollars for a company for the given years:Years Sales2001 3.12002 3.62003 4.32004 4.92005 5.22006 6.12007 6.92008 7.2a) Give the equation of the trend line for this time series. Round to 3 decimal places.b) Interpret the intercept in the context of this problem. Move decimal appropriately in your answer.c) Interpret the slope of sales in the context of this problem. Move decimal appropriately in your answer.d) Forecast sales for the year 2012. Move decimal appropriately in your answer.e) What % of the increase in sales is explained by the lineaer trend over the time series?4. The data below represent Y, sales in thousands of dollars; X1, price in cents; X2, promotion in dollars.Sales Price Promotion53 674 325059 628 358961 536 426663 521 487565 528 491271 506 576376 453 6173 83 399 6369a) Give the equation of the regression line. Round to 3 decimal places.b) Give the value of the slope for pricec) Interpret its meaning in the context of this problem. Move ethe decimal appropriatelyd) Give the value of the slope for promotion.e) Interpret its meaning in the context of this problem. Move the decimal appropriately.f) Predict sales for price of \$4.50 and \$6000 spent on promotion. Move the decimal appropriately.g) Give the calculated F for testing if the relationship is significant between sales & price and promition.h) What is its p-value?i) Is the relationship significant? Please answer yes or no.j) Give the coefficient of determination.k) Interpret its meaning in the context of this problem.l) Give the coefficient of partial determination for price. Show your calculations.m) Interpret its meaning in the context of this problem.n) Give the coefficient of partial determination for promotion. Show your calculations.o) Interpret its meaning in the context of this problem.5. Your factory produces 5 styles of coats. There are 5 rectangular areas (length and width in ft. are given) for each style of coat. Workers are paid \$25 per hour. From the data below, find for each style: 1) the total wholesale \$, 2) the total wages paid, 3) the total production cost, 4) the costs + wages as % of wholesale \$. Remember wholesale \$ is only for acceptable coats as we don’t sell rejects. Production costs are in dollars.Style of coat: length of area width of area #acceptable #rejected prod. cost\$ each coat/sq. ft. wholesale\$/coat # worker hrs/coat1 135 95 5786 452 .02 435 3.52 120 105 4468 354 .04 347 4.13 140 120 5637 259 .03 320 3.94 130 80 4903 395 .01 310 3.15 125 90 4039 349 .02 298 2.9

Don't use plagiarized sources. Get Your Custom Essay on
A sample of students was taken measuring the hours studied for a test
Just from \$13/Page
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.

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

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: