11 12 13 4 5 6 Use the CORREL function in cell J11 to determine if...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
11 12 13 4 5 6 Use the CORREL function in cell J11 to determine if there is a statistical relationship between the height and weight of the men in the sample. Use the FORECAST.LINEAR function (or the FORECAST function if you are not using Excel 2016) in cell J15 to predict Jim's weight from his height. Reference Jim's height in cell J14 and appropriate columns from the sample data table. In cells J18 and J19, use the information you calculated about the confidence interval for weight to determine the lower and upper bounds for the 95% confidence interval for your prediction of Jim's weight in cell J15. Be sure to reference the confidence interval calculation rather than hard coding it in your calculation. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 A B Subject 1 2 3 6 7 8 9 10 11 12 13 14 15 16 .... 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 22 32 33 34 35 36 37 38 39 40 41 BMI с Survey of Men's Weight and Height Weight Height 185.22 173.09 173.24 155.81 162.83 141.69 194.85 201.81 136.98 156.22 194.71 125.78 183.75 128.15 202.77 154.39 139.91 200.67 206.44 250.26 153.79 219.13 181.56 166.69 207.97 119.41 207.78 168.17 178.07 187.84 199.66 208.32 208.27 205.41 D 188.97 181.26 206.80 166.96 163.82 174.02 226.85 Baseball 72.74 69.03 70.21 68.76 70.94 67.50 76.92 70.74 63.36 70.40 70.61 72.47 70.82 70.82 71.02 70.00 70.06 70.35 72.92 72.77 79.44 70.09 72.38 70.93 70.58 68.89 71.43 68.94 68.88 68.66 71.56 68.38 70.92 70.83 70.76 72.65 69.16 68.23 67.23 67.22 69.59 72.43 E BMI 24.61 25.53 24 71 24.71 23.17 22.75 44000 21.86 23.15 28.35 23.99 22.16 27.46 16.84 25.76 17.86 29.09 23:05 22.11 19.87 26.53 27.41 27.88 22.01 29.41 50000 25.37 23.53 30.80 16.45 HOOR 30.74 24.92 26.55 25.78 30.02 29.11 29.18 28.84 25.17 26.64 31.23 25.97 25.49 25.27 30.40 F Count Average Standard* 95% CI** H Summary Statistics Weight I 200.00 173.67 32.45 4.50 Height 70.15 1.86 0.26 Correlation Correlation coefficient ---> Forecast*** Jim's Height (in inches)---> Predict Jim's Weight ---> Forecast Confidence Interval Lower Weight Bound ---> Upper Weight Bound ---> J BMI 70 24.78 4.34 0.60 *Note: the STDEV.S function is not available in Excel 2007. If you are using Excel 2007, use the STDEV funtion instead. ** Note: the CONFIDENCE.NORM function is not available in Excel 2007. If you are using Excel 2007, use the CONFIDENCE function instead. *** Note: the FORECAST.LINEAR function is not available prior to Excel 2016. If you are using a prior version of Excel, use the FORECAST function instead. K L M N 0 P Q R S 8 T U V W X 100% 11 12 13 4 5 6 Use the CORREL function in cell J11 to determine if there is a statistical relationship between the height and weight of the men in the sample. Use the FORECAST.LINEAR function (or the FORECAST function if you are not using Excel 2016) in cell J15 to predict Jim's weight from his height. Reference Jim's height in cell J14 and appropriate columns from the sample data table. In cells J18 and J19, use the information you calculated about the confidence interval for weight to determine the lower and upper bounds for the 95% confidence interval for your prediction of Jim's weight in cell J15. Be sure to reference the confidence interval calculation rather than hard coding it in your calculation. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 A B Subject 1 2 3 6 7 8 9 10 11 12 13 14 15 16 .... 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 22 32 33 34 35 36 37 38 39 40 41 BMI с Survey of Men's Weight and Height Weight Height 185.22 173.09 173.24 155.81 162.83 141.69 194.85 201.81 136.98 156.22 194.71 125.78 183.75 128.15 202.77 154.39 139.91 200.67 206.44 250.26 153.79 219.13 181.56 166.69 207.97 119.41 207.78 168.17 178.07 187.84 199.66 208.32 208.27 205.41 D 188.97 181.26 206.80 166.96 163.82 174.02 226.85 Baseball 72.74 69.03 70.21 68.76 70.94 67.50 76.92 70.74 63.36 70.40 70.61 72.47 70.82 70.82 71.02 70.00 70.06 70.35 72.92 72.77 79.44 70.09 72.38 70.93 70.58 68.89 71.43 68.94 68.88 68.66 71.56 68.38 70.92 70.83 70.76 72.65 69.16 68.23 67.23 67.22 69.59 72.43 E BMI 24.61 25.53 24 71 24.71 23.17 22.75 44000 21.86 23.15 28.35 23.99 22.16 27.46 16.84 25.76 17.86 29.09 23:05 22.11 19.87 26.53 27.41 27.88 22.01 29.41 50000 25.37 23.53 30.80 16.45 HOOR 30.74 24.92 26.55 25.78 30.02 29.11 29.18 28.84 25.17 26.64 31.23 25.97 25.49 25.27 30.40 F Count Average Standard* 95% CI** H Summary Statistics Weight I 200.00 173.67 32.45 4.50 Height 70.15 1.86 0.26 Correlation Correlation coefficient ---> Forecast*** Jim's Height (in inches)---> Predict Jim's Weight ---> Forecast Confidence Interval Lower Weight Bound ---> Upper Weight Bound ---> J BMI 70 24.78 4.34 0.60 *Note: the STDEV.S function is not available in Excel 2007. If you are using Excel 2007, use the STDEV funtion instead. ** Note: the CONFIDENCE.NORM function is not available in Excel 2007. If you are using Excel 2007, use the CONFIDENCE function instead. *** Note: the FORECAST.LINEAR function is not available prior to Excel 2016. If you are using a prior version of Excel, use the FORECAST function instead. K L M N 0 P Q R S 8 T U V W X 100%
Expert Answer:
Answer rating: 100% (QA)
Answer 1 The CORREL function in cell J11 is used to determine if there is a statistical relationship ... View the full answer
Related Book For
Business Statistics A Decision Making Approach
ISBN: 9780133021844
9th Edition
Authors: David F. Groebner, Patrick W. Shannon, Phillip C. Fry
Posted Date:
Students also viewed these accounting questions
-
The ER Model for Arkansas, Inc. database is based on the following business rules. - A department hires many employees. Each employee is hired by one department. - An employee is assigned to more...
-
Need help asap with physics questions 1. a) Write down the three lepton conservation laws, taking care to define all the terms. {3} b) For the neutrinos in the following reactions, assign the...
-
NEED ASAP WITH EXPLANATION PLEASE Social insurance exists to: Help solve social problems that results from economic changes beyond the control of both employers and employees Provide a base of...
-
Seeking for information of a specific organization then answer following questions: (1) Give a brief introduction of the chosen organization. (2) Explain the type of the chosen organization. What are...
-
What are the benefits and costs associated with dividends?
-
It has been reported that 20.4% of incoming freshmen indicate that they will major in business or a related field. A random sample of 400 incoming college freshmen was asked their preference, and 95...
-
To estimate earnings and cash flows on a typical project for the firm. Key Questions: 1. Does your firm have a typical investment? 2. If so, can you estimate the earnings and cash flows on a typical...
-
Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them...
-
Grant, Inc., is a well-known U.S. firm that needs to borrow L10 million to support a new business in the U.K. However, it cannot obtain financing from U.K. banks because it is not yet established...
-
You receive the following letter. Quark Pty Ltd. 500 Mowbray ROAD LANE COVE, NSW 2066 8 Sept 2018 Greetings, Quark Pty Ltd is a trader of machine parts. Its annual turnover in the last five years...
-
In this assignment, you will prepare a 23 page report that addresses the requirements specified in the case. Fully address each requirement and include at least two current references to scholarly...
-
Whether or not you believe the approach suggested in this article seems like it would be effective in addressing our system's "waste" issues? Are the theories advanced dependent upon whether or not...
-
Because liability is a major factor in health care delivery and because health care delivery systems and practitioners seek to minimize liability whenever possible, risk management has become a...
-
This week's video presentation quotes the Forman court as saying: "...people who intend to acquire only a residential apartment in a statesubsidized cooperative, for their personal use, are not...
-
CQI at Suburban Hospital Larry K. McReynolds Clara Maass Health System is composed of a 475-bed community hospital, a 120-bed long-term care facility, a 10-bed subacute care unit, and a visiting...
-
A written report with the following sections: Description, Who are the Consumers, What are the Consumption Benefits, Suggestions for Improvement. Please use these as headlines What is the payoff for...
-
Explore four of the different methods of neuroimaging (fMRI, CT, PET, EEG, ECG) that can be utilized to study ADHD by doing the following: Provide examples of neuropsychological findings related to...
-
A stock has had returns of 8 percent, 26 percent, 14 percent, 17 percent, 31 percent, and 1 percent over the last six years. What are the arithmetic and geometric average returns for the stock?
-
The National Association of Realtors (NAR) Existing-Home Sales Series provides a measurement of the residential real estate market. On or about the 25th of each month, NAR releases statistics on...
-
A survey by KRC Research for U.S. News reported that 37% of people plan to spend more on eating out after they retire. If eight people are randomly selected, then determine the a. expected number of...
-
The file Online contains a random sample of 48 customers who made purchases last quarter from an online retailer. The file contains information related to the time each customer spent viewing the...
-
After several weeks of searching for a new home, Rene has found a house that seems to be in good shape and is located in a nice neighborhood. The listing price is \($125,000,\) which is about...
-
Imagine that you are a condominium owner attending a meeting of the condominium association. What should the association do about a homeowner who leaves garbage in the hallway? Should the association...
-
Evaluate the various housing alternatives that are available.
Study smarter with the SolutionInn App