I performed a linear regression for the population to the, Ask an Expert

Statistics

I need a workable excel linear regression analysis worksheet using data from fall 13 and case 3 of comparing the population to the price, etc. I have to address the fact the company is looking to open more stores and would like a forecast of monthly profit for each store. I am to use regression models developed along with "3a" to predict monthly of the profit for each of the stores. Please just show me how and explain as much as possible. I performed a linear regression for the Population to the monthly profit, but do not understand how to use the information. And I do not understand the confidence interval estimate; how do I use and decipher the info.

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M9355742

Have any Question?Write your Review or question?

Related Questions in Statistics and Probability

A 54 percent corporate coupon bond is callable in ten years

A 5.4 percent corporate coupon bond is callable in ten years for a call premium of one year of coupon payments. Assuming a par value of $1,000, what is the price paid to the bondholder if the issuer calls the bond? Amoun ...

Letnbspnmnbspv denote the normal random variable with

Let N ( m , v ) denote the normal random variable with mean m and variance v . (a) If X is a Standard Normal variable, what is the distribution of the random variable 4 X - 1? (b) If X ~ N (3,1) and Y ~ ...

Suppose that 20 of men p20 and 15 of women p 15 are

Suppose that 20% of men (P=.20) and 15% of women (P= .15) are carriers of a particular genetic trait. That trait can only be inherited by a child if both parents are carriers. What is the probability that a child is born ...

A population has a mean of 400 and a standard deviation of

A population has a mean of 400 and a standard deviation of 50. Suppose a sample of size 125 is selected and is used to estimate . Use z-table. 1) What is the probability that the sample mean will be within +/- 6 of the p ...

Becky fenton has 408035 automobile insurance coverage if

Becky Fenton has 40/80/35 automobile insurance coverage. If two other people are awarded $70,000 each for injuries in an auto accident in which Becky was judged at fault, how much of this judgment would the insurance cov ...

Need help with calculating these problems a research group

Need help with calculating these problems: A research group conducted an extensive survey of 2957 wage and salaried workers on issues ranging from relationships with their bosses to household chores. The data were gather ...

Determine the internal rate of return for a project that

Determine the internal rate of return for a project that costs -$149,500 and would yield after-tax cash flows of $23,000 the first year, $25,000 the second year, $28,000 the third year, $30,000 the fourth year, $34,000 t ...

Consider the probability distribution shown belowx 0 1 2 px

Consider the probability distribution shown below. x 0 1 2 P(x) 0.65 0.30 0.05 Compute the expected value of the distribution. Compute the standard deviation of the distribution. (Round your answer to four decimal places ...

Imagine that i had two drugs x and z i administered the

Imagine that I had two drugs, X and Z. I administered the drugs to people with sleep difficulties for one month. The mean amount of sleep difficulties reported in the drug X group in the past month was 3.44 (SD = 2.34) a ...

Why is it that some people make very high returns on the

Why is it that some people make very high returns on the stock market if it is so efficient? Is it more difficult to reconcile very high returns with efficient markets if the same people make extraordinary returns year a ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert