Description
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
No 4: The answer is 2 cm
No.5: The answer is 12mm
Best my answer
Completion Status:
100%
Review
Review
Anonymous
Great! Studypool always delivers quality work.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Walden University Wk 3 Standard Deviation Units Exercises
Submit your responses to the following prompts.A market-research firm was hired to determine the percentage of people in a ...
Walden University Wk 3 Standard Deviation Units Exercises
Submit your responses to the following prompts.A market-research firm was hired to determine the percentage of people in a market area who would purchase a client’s magazine if a door-to-door sales campaign were undertaken. The firm stated that 40% would buy if contacted at home. Suppose the marketing company has tried the sales campaign at 300 randomly selected homes. (150–225 words, or 2–3 paragraphs)Assuming the market research was done properly and the 40% is representative, how many sales are expected if the publisher attempts to sell to 5,000 homes?If the market research was accurate, what is the probability that fewer than 100 individuals will buy? Use the normal approximation to the binomial.Suppose that the publisher actually sells the magazine to 70 people out of the 300 contacted. What would you conclude about the market research? About the campaign?A steel mill produces alloy sheets used for the bodies of automobiles. The mill produces sheets with an average thickness of 0.517 inches and a standard deviation of 0.037 inches. A new car model requires alloy sheets between 0.495 and 0.525 inches thick. What percentage of the sheets made by the mill will be suitable for the new car model? Explain your answer. (75 words, or 1 paragraph)The VP of HR for a large company is interested in the distribution of sick-leave hours for employees at the company. A recent study revealed that the distribution was consistent with a normal model, with a mean of 58 hours per year, and a standard deviation of 14 hours. An office manager of one division believes that during the past year, two of the division’s employees have taken excessive sick leave. One took 74 hours and the other used 90 hours. What would you conclude about the division manager’s claim, and why? (75 words, or 1 paragraph)Each month, an American household generates an average of 28 pounds of newspaper for garbage and/or recycling. Assume this is approximately normally distributed and that the standard deviation is 2 pounds. If a household is selected at random, find the probability of it generating between 27–31 pounds per month. (75 words, or 1 paragraph)Note: For each prompt, be sure to reference at least one scholarly source to support your answer. Use the Walden Undergraduate Paper Template, provided in this week’s Learning Resources, to complete this Assignment.
Precalculus Test
20 questions. Involves precalculus and trigonometry, Please show work and circle the final answer if posslble to make it e ...
Precalculus Test
20 questions. Involves precalculus and trigonometry, Please show work and circle the final answer if posslble to make it easier for me. Thank you so much.
Johns Hopkins University Sample Standard Deviation Statistics Homework 4
Statistics homework help.Please communicate with me while you are working on the homework.Thanks
Johns Hopkins University Sample Standard Deviation Statistics Homework 4
Statistics homework help.Please communicate with me while you are working on the homework.Thanks
4 pages
Visualization Of Data
For this study, the objective is the visualization of variables. Specifically, there will be visualization of both a categ ...
Visualization Of Data
For this study, the objective is the visualization of variables. Specifically, there will be visualization of both a categorical and continuous ...
Multiple regression project
Multiple Regression Project The is the only deliverable in Week Four. It is the case study titled “Locating New Pam an ...
Multiple regression project
Multiple Regression Project The is the only deliverable in Week Four. It is the case study titled “Locating New Pam and Susan’s Stores,” described at the end of Chapter 12 of your textbook. The case involves the decision to locate a new store at one of two candidate sites. The decision will be based on estimates of sales potential, and for this purpose, you will need to develop a multiple regression model to predict sales. Specific case questions are given in the textbook, and the necessary data is in the file named pamsue.xls. Assuming that you are reasonably comfortable with using Excel and its Analysis ToolPak add-in, you should expect to spend approximately 2-3 hours on computer work, and another 3-4 hours on writing the report. It is a good idea not to wait until the last day to do the entire project and write the report. Content of the report consists of your answers to the case questions, plus computer output(s) to support your answers. Please keep the entire report - including computer outputs - under 8 printed pages. Thus, your write up should be concise, and you need to be selective in deciding which computer outputs to include. You can use your discretion in formatting your write up, but use good writing practices and try to make it look professional (more on the report format below). Project Hints and Guidelines It is assumed that you have access to Microsoft Excel with Analysis ToolPak (do NOT use stepwise regression for this project even if it runs on your computer). Data file named pamsue.xls in the DataSets.zip folder. Basic Excel skills you need are the ability to construct histograms and scatterplots, to create dummy variables, copying or moving columns of data in a spreadsheet, and the ability to use the Correlation and Regression facilities under Data Analysis (available when Analysis ToolPak has been added in). Remember that Analysis ToolPak requires contiguous ranges of data for correlation or regression. Open the file pamsue.xls. First, move the column for sales so that it is the rightmost column (it is now to the right of comtype). If the old sales column remains but appears empty, delete that column. Obtain a scatterplot of the sales on the vertical axis against comtype on the horizontal axis. This will give you a good idea of whether different categories of comtype appear to differ in sales. In the scatterplot, you should see that sales in the middle categories 3 - 6 are in similar ranges on the vertical axis, but 1 and 2 have somewhat higher sales, and category 7 appears to have somewhat lower sales. This implies that, when you create dummy variables for comtype, dummy variables for categories 1, 2, 7 are likely to be statistically significant in the multiple regression model (and dummy variables for categories 3 - 6 are likely to be not significant). Although it would be desirable to also obtain the scatterplot of sales against every other X variable, you can omit these if you do not have time, and use the correlation coefficients instead (see step 4 below). Insert seven new columns immediately to the left of comtype, and in these columns, create seven dummy variables to represent the seven categories of site types. Name them comtype1, comtype2, ..., comtype7. At this point, you have 40 columns of data in the spreadsheet with comtype and sales in the last two columns. Use the Correlation facility under Data Analysis to obtain the correlation coefficients between sales and all of the other variables except store and comtype (why exclude comtype?). This will produce a matrix of correlation coefficients between sales and every X variable, as well as between every pair of X variables. To make them easy to read, you may want to format the cells to show numbers with 2 or 3 decimal places. Write down the names of 10 quantitative X variables having the highest correlations with sales. From the correlations worksheet, move to the data worksheet. Select the following columns: sales, plus the 10 quantitative X variables you wrote down, plus comtype1, comptype2, comptype7 (here, you could include up to three more dummy variables, but they are likely to be statistically not significant, so you can save some work - see 2. above). Copy these onto a blank worksheet. Make sure there are no blank columns in within the data range in the new worksheet. Note: To prevent unexpected changes in copying data when formulas are involved, use Paste Special with Values selected when pasting data into a new worksheet. Use Regression under Data Analysis to obtain the regression output table for sales using the variables in the columns you had selected, making sure that Labels and New Worksheet Ply checkboxes are checked, and leave the other boxes unchecked. On the name tab of the output sheet (at the bottom), change the name of the worksheet to Model1.Using appropriate statistics in the regression output table, see if any of the X variables is statistically not significant. If there is at least one insignificant X variable, write down the most insignificant variable, move to the data sheet and delete that column, and re-run Regression without that variable. Repeat until there are no insignificant X variables. Name each output sheet Model2, Model3, and so on for easy identification. When you get to a model in which all remaining X variables are statistically significant, you will have found the final regression equation for predicting sales. Re-run the last model, but this time checking the Residuals checkbox. This will reproduce the last regression table, but below it, you will see columns for Predicted sales and Residuals. Obtain a scatterplot of Residuals against Predicted sales. Also obtain a histogram of Residuals.Use the final regression equation you found in the last step to predict sales at the two sites under consideration. You have just completed all necessary computer work for your project report. Now you have to write a report to present your answers to the case questions (see pages 433-434 of your textbook), and the reasons for those answers. In terms of physical organization, a reasonable format for the report is described below. Content and Format of the Project Report Cover page Include the report title, your name, course, section, facilitator, and date. Go to a new page, and use the following subsection headings for the report. Introduction One paragraph (two at most) describing the subject and context of the project. Data One or two paragraphs describing the data in plain English (number of variables, number of observations, units for data values, etc.) Results and Discussion This is the main body of the report. It is where you will describe what you have done, what you found, and answer the case questions with the reasons for your answers. These reasons should be based on the analytical work you have done using Excel. Depending on how concisely you write and how many tables and graphs you include, this page could be 3-4 pages long. Conclusion One or two paragraphs discussing any remaining issues (e.g. shortcomings and possible improvements of the analyses in the report). In the Results and Discussion section, you should include a few informative tables or graphs derived from your computer analyses. DO NOT include anything that is not absolutely necessary. DO NOT include entire worksheets form Excel, but only the parts you need. For example, do not include the entire correlation matrix found in step 4 above, but you can make a small table to show the 10 variables having the highest correlations with sales. You should include the scatterplot of sales against comtype, relevant portion of the final regression output table, the final regression equation, and the two residual graphs you obtained in step 8. Please keep the total length of the report under 8 printed pages (5 to 6 pages should be sufficient in most cases). Please submit you report as a Word
Similar Content
Grantham University Algebra Discussions
S Dashboa x
S SOLUTIO X
S Ask a ne x
M PUBLIC SX
MInbox (1. X
Bb Review TX
f Messeng x
Dashboa X
G Home
х
C Discussio x
+...
Solve the following equations, algebra homework help
Can you hand write the problems out please....
MATH 1015 Harvard Business School Mathematics Questions
Math 1015
Test 1
September 29th , 2021
Read and follow all instructions. Show any necessary work and clearly write out ...
Interest Rates Discussion, math homework help
Interest rates are a fact of life that you will encounter both professionally and personally. One area of interest rates...
Cabarrus College of Health Sciences Mathematics Exam Practice
I want help with these questions, quickly delivered after two hours ...
Consumer Math Questions
Consumer Math Lesson 4.txtCould you please show the work and give the answer. Thank you!...
Linear Regression
...
Find M So That The Lines With Equations
Find M so that the lines with equations -2x + My = 5 and 4y + x = -9 are perpendicular. Explain how First we have to make ...
Untitled Document
Okay, so anytime you find a question about angles of elevation, the first step is to find a triangle. Here, the triangle i...
Related Tags
Book Guides
Slaughterhouse Five
by Kurt Vonnegut
Their Eyes Were Watching God
by Zora Neale Hurston
Heart of Darkness
by Joseph Conrad
Siddhartha
by Hermann Hesse
Jane Eyre
by Charlotte Brontë
The Hobbit
by J. R. R. Tolkien
Dracula
by Bram Stoker
The Adventures of Huckleberry Finn
by Mark Twain
The Splendid and The Vile
by Erik Larson
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Walden University Wk 3 Standard Deviation Units Exercises
Submit your responses to the following prompts.A market-research firm was hired to determine the percentage of people in a ...
Walden University Wk 3 Standard Deviation Units Exercises
Submit your responses to the following prompts.A market-research firm was hired to determine the percentage of people in a market area who would purchase a client’s magazine if a door-to-door sales campaign were undertaken. The firm stated that 40% would buy if contacted at home. Suppose the marketing company has tried the sales campaign at 300 randomly selected homes. (150–225 words, or 2–3 paragraphs)Assuming the market research was done properly and the 40% is representative, how many sales are expected if the publisher attempts to sell to 5,000 homes?If the market research was accurate, what is the probability that fewer than 100 individuals will buy? Use the normal approximation to the binomial.Suppose that the publisher actually sells the magazine to 70 people out of the 300 contacted. What would you conclude about the market research? About the campaign?A steel mill produces alloy sheets used for the bodies of automobiles. The mill produces sheets with an average thickness of 0.517 inches and a standard deviation of 0.037 inches. A new car model requires alloy sheets between 0.495 and 0.525 inches thick. What percentage of the sheets made by the mill will be suitable for the new car model? Explain your answer. (75 words, or 1 paragraph)The VP of HR for a large company is interested in the distribution of sick-leave hours for employees at the company. A recent study revealed that the distribution was consistent with a normal model, with a mean of 58 hours per year, and a standard deviation of 14 hours. An office manager of one division believes that during the past year, two of the division’s employees have taken excessive sick leave. One took 74 hours and the other used 90 hours. What would you conclude about the division manager’s claim, and why? (75 words, or 1 paragraph)Each month, an American household generates an average of 28 pounds of newspaper for garbage and/or recycling. Assume this is approximately normally distributed and that the standard deviation is 2 pounds. If a household is selected at random, find the probability of it generating between 27–31 pounds per month. (75 words, or 1 paragraph)Note: For each prompt, be sure to reference at least one scholarly source to support your answer. Use the Walden Undergraduate Paper Template, provided in this week’s Learning Resources, to complete this Assignment.
Precalculus Test
20 questions. Involves precalculus and trigonometry, Please show work and circle the final answer if posslble to make it e ...
Precalculus Test
20 questions. Involves precalculus and trigonometry, Please show work and circle the final answer if posslble to make it easier for me. Thank you so much.
Johns Hopkins University Sample Standard Deviation Statistics Homework 4
Statistics homework help.Please communicate with me while you are working on the homework.Thanks
Johns Hopkins University Sample Standard Deviation Statistics Homework 4
Statistics homework help.Please communicate with me while you are working on the homework.Thanks
4 pages
Visualization Of Data
For this study, the objective is the visualization of variables. Specifically, there will be visualization of both a categ ...
Visualization Of Data
For this study, the objective is the visualization of variables. Specifically, there will be visualization of both a categorical and continuous ...
Multiple regression project
Multiple Regression Project The is the only deliverable in Week Four. It is the case study titled “Locating New Pam an ...
Multiple regression project
Multiple Regression Project The is the only deliverable in Week Four. It is the case study titled “Locating New Pam and Susan’s Stores,” described at the end of Chapter 12 of your textbook. The case involves the decision to locate a new store at one of two candidate sites. The decision will be based on estimates of sales potential, and for this purpose, you will need to develop a multiple regression model to predict sales. Specific case questions are given in the textbook, and the necessary data is in the file named pamsue.xls. Assuming that you are reasonably comfortable with using Excel and its Analysis ToolPak add-in, you should expect to spend approximately 2-3 hours on computer work, and another 3-4 hours on writing the report. It is a good idea not to wait until the last day to do the entire project and write the report. Content of the report consists of your answers to the case questions, plus computer output(s) to support your answers. Please keep the entire report - including computer outputs - under 8 printed pages. Thus, your write up should be concise, and you need to be selective in deciding which computer outputs to include. You can use your discretion in formatting your write up, but use good writing practices and try to make it look professional (more on the report format below). Project Hints and Guidelines It is assumed that you have access to Microsoft Excel with Analysis ToolPak (do NOT use stepwise regression for this project even if it runs on your computer). Data file named pamsue.xls in the DataSets.zip folder. Basic Excel skills you need are the ability to construct histograms and scatterplots, to create dummy variables, copying or moving columns of data in a spreadsheet, and the ability to use the Correlation and Regression facilities under Data Analysis (available when Analysis ToolPak has been added in). Remember that Analysis ToolPak requires contiguous ranges of data for correlation or regression. Open the file pamsue.xls. First, move the column for sales so that it is the rightmost column (it is now to the right of comtype). If the old sales column remains but appears empty, delete that column. Obtain a scatterplot of the sales on the vertical axis against comtype on the horizontal axis. This will give you a good idea of whether different categories of comtype appear to differ in sales. In the scatterplot, you should see that sales in the middle categories 3 - 6 are in similar ranges on the vertical axis, but 1 and 2 have somewhat higher sales, and category 7 appears to have somewhat lower sales. This implies that, when you create dummy variables for comtype, dummy variables for categories 1, 2, 7 are likely to be statistically significant in the multiple regression model (and dummy variables for categories 3 - 6 are likely to be not significant). Although it would be desirable to also obtain the scatterplot of sales against every other X variable, you can omit these if you do not have time, and use the correlation coefficients instead (see step 4 below). Insert seven new columns immediately to the left of comtype, and in these columns, create seven dummy variables to represent the seven categories of site types. Name them comtype1, comtype2, ..., comtype7. At this point, you have 40 columns of data in the spreadsheet with comtype and sales in the last two columns. Use the Correlation facility under Data Analysis to obtain the correlation coefficients between sales and all of the other variables except store and comtype (why exclude comtype?). This will produce a matrix of correlation coefficients between sales and every X variable, as well as between every pair of X variables. To make them easy to read, you may want to format the cells to show numbers with 2 or 3 decimal places. Write down the names of 10 quantitative X variables having the highest correlations with sales. From the correlations worksheet, move to the data worksheet. Select the following columns: sales, plus the 10 quantitative X variables you wrote down, plus comtype1, comptype2, comptype7 (here, you could include up to three more dummy variables, but they are likely to be statistically not significant, so you can save some work - see 2. above). Copy these onto a blank worksheet. Make sure there are no blank columns in within the data range in the new worksheet. Note: To prevent unexpected changes in copying data when formulas are involved, use Paste Special with Values selected when pasting data into a new worksheet. Use Regression under Data Analysis to obtain the regression output table for sales using the variables in the columns you had selected, making sure that Labels and New Worksheet Ply checkboxes are checked, and leave the other boxes unchecked. On the name tab of the output sheet (at the bottom), change the name of the worksheet to Model1.Using appropriate statistics in the regression output table, see if any of the X variables is statistically not significant. If there is at least one insignificant X variable, write down the most insignificant variable, move to the data sheet and delete that column, and re-run Regression without that variable. Repeat until there are no insignificant X variables. Name each output sheet Model2, Model3, and so on for easy identification. When you get to a model in which all remaining X variables are statistically significant, you will have found the final regression equation for predicting sales. Re-run the last model, but this time checking the Residuals checkbox. This will reproduce the last regression table, but below it, you will see columns for Predicted sales and Residuals. Obtain a scatterplot of Residuals against Predicted sales. Also obtain a histogram of Residuals.Use the final regression equation you found in the last step to predict sales at the two sites under consideration. You have just completed all necessary computer work for your project report. Now you have to write a report to present your answers to the case questions (see pages 433-434 of your textbook), and the reasons for those answers. In terms of physical organization, a reasonable format for the report is described below. Content and Format of the Project Report Cover page Include the report title, your name, course, section, facilitator, and date. Go to a new page, and use the following subsection headings for the report. Introduction One paragraph (two at most) describing the subject and context of the project. Data One or two paragraphs describing the data in plain English (number of variables, number of observations, units for data values, etc.) Results and Discussion This is the main body of the report. It is where you will describe what you have done, what you found, and answer the case questions with the reasons for your answers. These reasons should be based on the analytical work you have done using Excel. Depending on how concisely you write and how many tables and graphs you include, this page could be 3-4 pages long. Conclusion One or two paragraphs discussing any remaining issues (e.g. shortcomings and possible improvements of the analyses in the report). In the Results and Discussion section, you should include a few informative tables or graphs derived from your computer analyses. DO NOT include anything that is not absolutely necessary. DO NOT include entire worksheets form Excel, but only the parts you need. For example, do not include the entire correlation matrix found in step 4 above, but you can make a small table to show the 10 variables having the highest correlations with sales. You should include the scatterplot of sales against comtype, relevant portion of the final regression output table, the final regression equation, and the two residual graphs you obtained in step 8. Please keep the total length of the report under 8 printed pages (5 to 6 pages should be sufficient in most cases). Please submit you report as a Word
Earn money selling
your Study Documents