LEARN MORE...

Stathw

Content type

User Generated

Subject

Statistics

School

Grand Canyon University

Type

Homework

Uploaded By

Znqvanovyn099

Pages

4

Showing Page:

1/4

Sign up to view the full document!

Showing Page:

2/4

Sign up to view the full document!

Showing Page:

3/4

Sign up to view the full document!

End of Preview - Want to read all 4 pages?

Unformatted Attachment Preview

9.13 Given a sample size of 36, how large does the population standard deviation have to be in order for the standard error to be (a) 1 ? (b) 2 ? (c) 5 ? (d) 100 ? The standard error is: 𝑆𝐸 = 𝜎 √𝑁 Where 𝜎 is the population standard deviation and 𝑁 is the sample size. We can solve for 𝜎 and obtain, 𝜎 = 𝑆𝐸√𝑁 Therefore, if we have a sample size of 𝑁 = 36, we obtain, 𝜎 = 𝑆𝐸√36 = 6𝑆𝐸 Thus, we can calculate how large the population standard deviation must be to obtain a given standard error 𝑆𝐸. The following table summarizes the results, Standard Error How large the population standard deviation (SE) value (𝝈) must be (a) 1 𝜎 = 6𝑆𝐸 = 6(1) = 6 (b) 2 𝜎 = 6𝑆𝐸 = 6(2) = 12 (c) 5 𝜎 = 6𝑆𝐸 = 6(5) = 30 (d) 100 𝜎 = 6𝑆𝐸 = 6(100) = 600 In conclusion, for larger standard deviation values, the standard error is greater. 10.10 Let’s assume that, over the years, a paper and pencil test of anxiety yields a mean score of 35 for all incoming college freshmen. We wish to determine whether the scores of a random sample of 20 new freshmen, with a mean of 30 and a standard deviation of 10, ...
Purchase document to see full attachment

Tags: Population Standard Deviation Production line discrimination against female candy plant boxes of candy

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Studypool

4.7

Indeed

4.5

Sitejabber

4.4

24/7 Study Help

Stuck on a study question? Our verified tutors can answer all questions, from basic math to advanced rocket science!

Post question

6 pages

Homework Questions

1. A shipping firm suspects that the mean life of a certain brand of tire used by its trucks is less

Homework Questions

1. A shipping firm suspects that the mean life of a certain brand of tire used by its trucks is less

DAT 565 UCLA Wk 5 Regression Analysis Predicting Tax Assessment Value Worksheet

This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression model ...

DAT 565 UCLA Wk 5 Regression Analysis Predicting Tax Assessment Value Worksheet

This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models.Resources: Microsoft Excel®, DAT565_v3_Wk5_Data_FileInstructions: The Excel file for this assignment contains a database with information about the tax assessment value assigned to medical office buildings in a city. The following is a list of the variables in the database:FloorArea: square feet of floor spaceOffices: number of offices in the buildingEntrances: number of customer entrancesAge: age of the building (years)AssessedValue: tax assessment value (thousands of dollars)Use the data to construct a model that predicts the tax assessment value assigned to medical office buildings with specific characteristics.Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?Use Excel’s Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue. Is FloorArea a significant predictor of AssessmentValue?Construct a scatter plot in Excel with Age as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?Use Excel’s Analysis ToolPak to conduct a regression analysis of Age and Assessment Value. Is Age a significant predictor of AssessmentValue?Construct a multiple regression model.Use Excel’s Analysis ToolPak to conduct a regression analysis with AssessmentValue as the dependent variable and FloorArea, Offices, Entrances, and Age as independent variables. What is the overall fit r^2? What is the adjusted r^2?Which predictors are considered significant if we work with α=0.05? Which predictors can be eliminated?What is the final model if we only use FloorArea and Offices as predictors?Suppose our final model is:AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x OfficesWhat wouldbe the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago? Is this assessed value consistent with what appears in the database?

14 pages

A soft drink bottler is analyzing the vending machine service routes in his distribution system. He is interested in predi ...

A soft drink bottler is analyzing the vending machine service routes in his distribution system. He is interested in predicting the amount of time ...

Quantitive Reasoning (Probabilities), homework help

Quantitive Reasoning (Probabilities), homework help

5 pages

Chi Square Problem 10 31

1. Which question are you investigating? Copy and paste the question into your response. The question I choose to investig ...

Chi Square Problem 10 31

1. Which question are you investigating? Copy and paste the question into your response. The question I choose to investigate is: For the population ...

MATH302 University of Phoenix Mercer Human Resources Data Analysis

Assignment InstructionsA marketing company based out of New York City is doing well and is looking to expand international ...

MATH302 University of Phoenix Mercer Human Resources Data Analysis

Assignment InstructionsA marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to enlist the help of a consulting firm that you work for, to help collect data and analyze market trends. You work for Mercer Human Resources. The Mercer Human Resource Consulting website (www.mercer.com) lists prices of certain items in selected cities around the world. They also report an overall cost-of-living index for each city compared to the costs of hundreds of items in New York City (NYC). For example, London at 88.33 is 11.67% less expensive than NYC.More specifically, if you choose to explore the website further you will find a lot of fun and interesting data. You can explore the website more on your own after the course concludes.https://mobilityexchange.mercer.com/Insights/cost-...In the Excel document, you will find the 2018 data for 17 cities in the data set Cost of Living. Included are the 2018 cost of living index, cost of a 3-bedroom apartment (per month), price of monthly transportation pass, price of a mid-range bottle of wine, price of a loaf of bread (1 lb.), the price of a gallon of milk and price for a 12 oz. cup of black coffee. All prices are in U.S. dollars.You use this information to run a Multiple Linear Regression to predict Cost of living, along with calculating various descriptive statistics. This is given in the Excel output (that is, the MLR has already been calculated. Your task is to interpret the data). Based on this information, in which city should you open a second office in? You must justify your answer. If you want to recommend 2 or 3 different cities and rank them based on the data and your findings, this is fine as well. This should be ¾ to 1 page, no more than 1 single-spaced page in length, using 12-point Times New Roman font. You do not need to do any calculations, but you do need to pick a city to open a second location at and justify your answer based upon the provided results of the Multiple Linear Regression. Think of this assignment as the first page of a much longer report, known as an Executive Summary, that essentially summarizes your findings briefly and at a high level. This needs to be written up neatly and professionally. This would be something you would present at a board meeting in a corporate environment.What is an Executive Summary https://www.surveygizmo.com/resources/blog/how-to-...To help you make this decision here are some things to consider:Based on the MLR output, what variable(s) is/are significant? From the significant predictors, review the mean, median, min, max, Q1 and Q3 values? It might be a good idea to compare these values to what the New York value is for that variable. Remember New York is the baseline as that is where headquarters are located.Based on the descriptive statistics, for the significant predictors, what city/cities has the best potential? What city or cities fall above or below the median and/or the mean? What city or cities are in the upper 3rd quartile? Or the bottom quartile? These are some things to consider not necessarily questions you need to answer in your Executive Summary. But they are questions to help guide you along in your analysis.

Similar Documents

Algebra questions need help

algebra 2.docx ...

What is geometry ?

Download your exam and type in your answers. Please also feel free to also write your answers out and upload your submissi...

Factor the polynomial and use the factored form to find the zeros. (Enter your a

Factor the polynomial and use the factored form to find the zeros. (Enter your answers as a comma-separated list.)P(x) =&n...

Need algebra help to Find f(g(x)) and g(f(x)), then determine if f and; g are inverses of each other

Random Variable Discussion

Extra Credit 3160 Info Monday, April 27, 2020 11:10 AM Quick Notes 2 Page 1 Kochanowic z Math 31... Quick Notes 2 Pag...

Determine whether each x-value is a solution (or an approximate solution) of the

Determine whether each x-value is a solution (or an approximate solution) of the equation. 23x + 5 = 128 (...

T Test In Practice.edited

In the course of carrying out quantitative analysis, researchers use various mathematical tests for further investigation ...

1. The independent sample T test is less powerful, on average, than a dependent samples T test because it has more variabi...

Spreadsheet Parti

Study help

Our tutors provide high quality explanations & answers.

Post question

6 pages

Homework Questions

1. A shipping firm suspects that the mean life of a certain brand of tire used by its trucks is less

Homework Questions

1. A shipping firm suspects that the mean life of a certain brand of tire used by its trucks is less

DAT 565 UCLA Wk 5 Regression Analysis Predicting Tax Assessment Value Worksheet

This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression model ...

DAT 565 UCLA Wk 5 Regression Analysis Predicting Tax Assessment Value Worksheet

This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models.Resources: Microsoft Excel®, DAT565_v3_Wk5_Data_FileInstructions: The Excel file for this assignment contains a database with information about the tax assessment value assigned to medical office buildings in a city. The following is a list of the variables in the database:FloorArea: square feet of floor spaceOffices: number of offices in the buildingEntrances: number of customer entrancesAge: age of the building (years)AssessedValue: tax assessment value (thousands of dollars)Use the data to construct a model that predicts the tax assessment value assigned to medical office buildings with specific characteristics.Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?Use Excel’s Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue. Is FloorArea a significant predictor of AssessmentValue?Construct a scatter plot in Excel with Age as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?Use Excel’s Analysis ToolPak to conduct a regression analysis of Age and Assessment Value. Is Age a significant predictor of AssessmentValue?Construct a multiple regression model.Use Excel’s Analysis ToolPak to conduct a regression analysis with AssessmentValue as the dependent variable and FloorArea, Offices, Entrances, and Age as independent variables. What is the overall fit r^2? What is the adjusted r^2?Which predictors are considered significant if we work with α=0.05? Which predictors can be eliminated?What is the final model if we only use FloorArea and Offices as predictors?Suppose our final model is:AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x OfficesWhat wouldbe the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago? Is this assessed value consistent with what appears in the database?

14 pages

A soft drink bottler is analyzing the vending machine service routes in his distribution system. He is interested in predi ...

A soft drink bottler is analyzing the vending machine service routes in his distribution system. He is interested in predicting the amount of time ...

Quantitive Reasoning (Probabilities), homework help

Quantitive Reasoning (Probabilities), homework help

5 pages

Chi Square Problem 10 31

1. Which question are you investigating? Copy and paste the question into your response. The question I choose to investig ...

Chi Square Problem 10 31

1. Which question are you investigating? Copy and paste the question into your response. The question I choose to investigate is: For the population ...

MATH302 University of Phoenix Mercer Human Resources Data Analysis

Assignment InstructionsA marketing company based out of New York City is doing well and is looking to expand international ...

MATH302 University of Phoenix Mercer Human Resources Data Analysis

Assignment InstructionsA marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to enlist the help of a consulting firm that you work for, to help collect data and analyze market trends. You work for Mercer Human Resources. The Mercer Human Resource Consulting website (www.mercer.com) lists prices of certain items in selected cities around the world. They also report an overall cost-of-living index for each city compared to the costs of hundreds of items in New York City (NYC). For example, London at 88.33 is 11.67% less expensive than NYC.More specifically, if you choose to explore the website further you will find a lot of fun and interesting data. You can explore the website more on your own after the course concludes.https://mobilityexchange.mercer.com/Insights/cost-...In the Excel document, you will find the 2018 data for 17 cities in the data set Cost of Living. Included are the 2018 cost of living index, cost of a 3-bedroom apartment (per month), price of monthly transportation pass, price of a mid-range bottle of wine, price of a loaf of bread (1 lb.), the price of a gallon of milk and price for a 12 oz. cup of black coffee. All prices are in U.S. dollars.You use this information to run a Multiple Linear Regression to predict Cost of living, along with calculating various descriptive statistics. This is given in the Excel output (that is, the MLR has already been calculated. Your task is to interpret the data). Based on this information, in which city should you open a second office in? You must justify your answer. If you want to recommend 2 or 3 different cities and rank them based on the data and your findings, this is fine as well. This should be ¾ to 1 page, no more than 1 single-spaced page in length, using 12-point Times New Roman font. You do not need to do any calculations, but you do need to pick a city to open a second location at and justify your answer based upon the provided results of the Multiple Linear Regression. Think of this assignment as the first page of a much longer report, known as an Executive Summary, that essentially summarizes your findings briefly and at a high level. This needs to be written up neatly and professionally. This would be something you would present at a board meeting in a corporate environment.What is an Executive Summary https://www.surveygizmo.com/resources/blog/how-to-...To help you make this decision here are some things to consider:Based on the MLR output, what variable(s) is/are significant? From the significant predictors, review the mean, median, min, max, Q1 and Q3 values? It might be a good idea to compare these values to what the New York value is for that variable. Remember New York is the baseline as that is where headquarters are located.Based on the descriptive statistics, for the significant predictors, what city/cities has the best potential? What city or cities fall above or below the median and/or the mean? What city or cities are in the upper 3rd quartile? Or the bottom quartile? These are some things to consider not necessarily questions you need to answer in your Executive Summary. But they are questions to help guide you along in your analysis.