Calculus and Above

Calculus Questions? Ask a Mathematician for Answers ASAP

Connect one-on-one with {0} who will answer your question

Hello, I need help answering...

Hello, I need help answering these statistical problems by Sept 2, 2014, 12pm eastern time. The answers have to be fully explained and showed in excel. Problems should be explained in writing in a separate tab for each problem and each answer should include the proper & necessary excel functions and graphs. Below is the uploaded file of problems 1-3, the number tables for #2 and #3 are in file as well.

http://wikisend.com/download/335450/Problem Set3.doc

Hypothesis Testing

1. University of Maryland University College is concerned that out of state students may be receiving lower grades than Maryland students. Two independent random samples have been selected: 165 observations from population 1 (Out of state students) and 177 from population 2 (Maryland students). The sample means obtained are X1(bar)=86 and X2(bar)=87. It is known from previous studies that the population variances are 8.1 and 7.3 respectively. Using a level of significance of .01, is there evidence that the out of state students may be receiving lower grades? Fully explain your answer.

Simple Regression

2. A CEO of a large pharmaceutical company would like to determine if the company should be placing more money allotted in the budget next year for television advertising of a new drug marketed for controlling diabetes. He wonders whether there is a strong relationship between the amount of money spent on television advertising for this new drug called DIB and the number of orders received. The manufacturing process of this drug is very difficult and requires stability so the CEO would prefer to generate a stable number of orders. The cost of advertising is always an important consideration in the phase I roll-out of a new drug. Data that have been collected over the past 20 months indicate the amount of money spent of television advertising and the number of orders received.

The use of linear regression is a critical tool for a manager's decision-making ability. Please carefully read the example below and try to answer the questions in terms of the problem context. The results are as follows:

a. Set up a scatter diagram and calculate the associated correlation coefficient. Discuss how strong you think the relationship is between the amount of money spent on television advertising and the number of orders received. Please use the Correlation procedures within Excel under Tools > Data Analysis. The Scatterplot can more easily be generated using the Chart procedure.

NOTE: If you do not have the Data Analysis option under Tools you must install it. You need to go to Tools select Add-ins and then choose the 2 data toolpak options. It should take about a minute.

b. Assuming there is a statistically significant relationship, use the least squares method to find the regression equation to predict the advertising costs based on the number of orders received. Please use the regression procedure within Excel under Tools > Data Analysis to construct this equation.

c. Interpret the meaning of the slope, b1, in the regression equation.

d. Predict the monthly advertising cost when the number of orders is 2,300,000. (Hint: Be very careful with assigning the dependent variable for this problem)

e. Compute the coefficient of determination, r2, and interpret its meaning.

f. Compute the standard error of estimate, and interpret its meaning.

g. Do you think that the company should use these results from the regression to base any corporate decisions on?….explain fully.

Hypothesis Testing on Multiple Populations

3. Dr. Michaella Evans, a statistics professor at the University of Maryland University College, drives from her home to the school every weekday. She has three options to drive there. She can take the Beltway, or she can take a main highway with some traffic lights, or she can take the back road, which has no traffic lights but is a longer distance. Being as data-oriented as she is, she is interested to know if there is a difference in the time it takes to drive each route.

As an experiment she randomly selected the route on 21 different days and wrote down the time it took her for the round trip, getting to work in the morning and back home in the evening. At the .01 significance level, can she conclude that there is a difference between the driving times using the different routes?

Time (in minutes) it took to get to work and back using:

You can check your critical value with the following table: http://www.statsoft.com/textbook/distribution-tables

http://wikisend.com/download/335450/Problem Set3.doc

Hypothesis Testing

1. University of Maryland University College is concerned that out of state students may be receiving lower grades than Maryland students. Two independent random samples have been selected: 165 observations from population 1 (Out of state students) and 177 from population 2 (Maryland students). The sample means obtained are X1(bar)=86 and X2(bar)=87. It is known from previous studies that the population variances are 8.1 and 7.3 respectively. Using a level of significance of .01, is there evidence that the out of state students may be receiving lower grades? Fully explain your answer.

Simple Regression

2. A CEO of a large pharmaceutical company would like to determine if the company should be placing more money allotted in the budget next year for television advertising of a new drug marketed for controlling diabetes. He wonders whether there is a strong relationship between the amount of money spent on television advertising for this new drug called DIB and the number of orders received. The manufacturing process of this drug is very difficult and requires stability so the CEO would prefer to generate a stable number of orders. The cost of advertising is always an important consideration in the phase I roll-out of a new drug. Data that have been collected over the past 20 months indicate the amount of money spent of television advertising and the number of orders received.

The use of linear regression is a critical tool for a manager's decision-making ability. Please carefully read the example below and try to answer the questions in terms of the problem context. The results are as follows:

a. Set up a scatter diagram and calculate the associated correlation coefficient. Discuss how strong you think the relationship is between the amount of money spent on television advertising and the number of orders received. Please use the Correlation procedures within Excel under Tools > Data Analysis. The Scatterplot can more easily be generated using the Chart procedure.

NOTE: If you do not have the Data Analysis option under Tools you must install it. You need to go to Tools select Add-ins and then choose the 2 data toolpak options. It should take about a minute.

b. Assuming there is a statistically significant relationship, use the least squares method to find the regression equation to predict the advertising costs based on the number of orders received. Please use the regression procedure within Excel under Tools > Data Analysis to construct this equation.

c. Interpret the meaning of the slope, b1, in the regression equation.

d. Predict the monthly advertising cost when the number of orders is 2,300,000. (Hint: Be very careful with assigning the dependent variable for this problem)

e. Compute the coefficient of determination, r2, and interpret its meaning.

f. Compute the standard error of estimate, and interpret its meaning.

g. Do you think that the company should use these results from the regression to base any corporate decisions on?….explain fully.

Hypothesis Testing on Multiple Populations

3. Dr. Michaella Evans, a statistics professor at the University of Maryland University College, drives from her home to the school every weekday. She has three options to drive there. She can take the Beltway, or she can take a main highway with some traffic lights, or she can take the back road, which has no traffic lights but is a longer distance. Being as data-oriented as she is, she is interested to know if there is a difference in the time it takes to drive each route.

As an experiment she randomly selected the route on 21 different days and wrote down the time it took her for the round trip, getting to work in the morning and back home in the evening. At the .01 significance level, can she conclude that there is a difference between the driving times using the different routes?

Time (in minutes) it took to get to work and back using:

You can check your critical value with the following table: http://www.statsoft.com/textbook/distribution-tables

Show More

Show Less

Was this answer helpful?

Describe your issueThe assistant will guide you

Chat 1:1 with a tutorLicensed Experts are available 24/7

100% satisfaction guaranteeGet all the answers you need

Related Calculus and Above Questions

Analyze the data using regression. Remember to use some of

Analyze the data using regression. Remember to use some of the calculation above.Calculate the slope.Calculate the intercept.Base on your regression results:Interpret the slopeInterpret the constant.7… read more

Here is your data set problem: Sales Advertising Price # of

Here is your data set for this problem:Sales Advertising Price # ***** stores 41 20 40 1 42 40 60 3 59 40 20 4 60 50 80 5 81 50 10 6 80 60 40 6 100 70 20 7 82 70 60 8 101 80 30 9 110 90 40 10Hills Lig… read more

1. University of Maryland University College is concerned

1. University of Maryland University College is concerned that out of state students may be receiving lower grades than Maryland students. Two independent random samples have been selected: 165 observ… read more

1. University of Maryland University College is concerned that

1. University of Maryland University College is concerned that out of state students may be receiving lower grades than Maryland students. Two independent random samples have been selected: 165 observ… read more

Hypothesis Testing 1. University of Maryland University

Hypothesis Testing 1. University of Maryland University College is concerned that out of state students may be receiving lower grades than Maryland students. Two independent random samples have been s… read more

Hypothesis Testing 1. A school is concerned that out

Hypothesis Testing 1. A school is concerned that out of state students may be receiving lower grades than another group of students. Two independent random samples have been selected: 165 observations… read more

its just like the questions you helped the person with here

its just like the questions you helped the person with here but with different numbers.... For questions 2 and 3 you will need the data analysis tools in Excel. please also give lament, simple explana… read more

What is the population, the sample, the statistic, and the

Answer any 3 of these question What is the population, the sample, the statistic, and the parameter in the studies described below? What type of data was gathered or will be gathered in the study? 1. … read more

Simple Regression A CEO of a large plastics manufacturing

Simple Regression A CEO of a large plastics manufacturing company would like to determine if she should be placing more money allotted in the budget next year for television advertising of a new baby … read more

13. A researcher is interested in whether herbal remedies are

13. A researcher is interested in whether herbal remedies are effective in relieving allergies, and if so, which ones are most effective. The researcher takes a group of 20 allergy sufferers and rando… read more

A CEO of a large pharmaceutical company would like to determine

A CEO of a large pharmaceutical company would like to determine if he should be placing more money allotted in the budget next year for television advertising of a new drug marketed for controlling di… read more

A CEO of a large pharmaceutical company would like to determine

A CEO of a large pharmaceutical company would like to determine if he should be placing more money allotted in the budget next year for television advertising of a new drug marketed for controlling di… read more

Hey John, Thanks for the help on the previous questions.

Hey John, Thanks for the help on the previous questions. As promised here is the other one. If you can get it to me tomorrow, that will be fine. It's a longer one but I will also take that into consid… read more

Hi Ryan,Are you available to help me out with a problem?

Hi Ryan, Are you available to help me out with a problem? 12.26 Number of Orders and Shipping Cost (n = 12 orders) ShipCost Orders (X) ($) Ship Cost (Y) 1,068 4,489 1,026 5,611 767 3,290 885 4,113 1,1… read more

Hypothesis Testing 1. The Connecticut Board of Education

Hypothesis Testing 1. The Connecticut Board of Education is concerned that first year female High school teachers are receiving lower salaries than their male counterparts. Two independent random samp… read more

Statistical HomeworkFor questions 2 and 3 you will need the

Statistical Homework For questions 2 and 3 you will need the data analysis tools in Excel. please also give lament, simple explanation of how to solve problem. In question 2 you will use the regressio… read more

1. (TCO 1) What method of data collection would you use to

1. (TCO 1) What method of data collection would you use to collect data for a study where a drug was given to 10 patients and a placebo to another group of 10 patients to determine if the drug has an … read more

An economist for the federal government is attempting to produce

An economist for the federal government is attempting to produce a better measure of poverty than is currently in use. To help acquire information, she recorded the annual household income (in $1,000s… read more

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.

JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.

Web sites like justanswer.com/legal

...leave nothing to chance.

...leave nothing to chance.

Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.

Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.

I will tell you that...the things you have to go through to be an Expert are quite rigorous.

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

Los Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

Hesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

Kernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

Woodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

Elkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

Dallas, TX

< Previous | Next >

Mr. Gregory White

Master's Degree

114 satisfied customers

M.A., M.S. Education / Educational Administration

SusanAthena

Master's Degree

102 satisfied customers

Tutor for Algebra, Geometry, Statistics. Explaining math in plain English.

Dr Arthur Rubin

Doctoral Degree

97 satisfied customers

Ph.D. in Mathematics, 1978, from the California Institute of Technology, over 20 published papers

JACUSTOMER-yrynbdjl-

Master's Degree

42 satisfied customers

I have a MS in Mathematics and I have taught Mathematics for 10 years at the college level.

Don

Master's Degree

29 satisfied customers

M.S. Astronautical Engineering. Math/Sci/Comp Tutor

Kofi

PhD in Statistics

7,955 satisfied customers

Masters in Mathematics and Statistics

Sandhya_sharma

Master's Degree

5,547 satisfied customers

I hold M.Sc and M.Phil degrees in math and have several years of teaching experience.

< Previous | Next >

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.