And now here we are…a Starbucks on nearly every corner. Even Homer Simpson had something to say about this in a recent episode! This is where I need your help. I would like you to perform a thorough analysis of the data involving the number of Starbucks locations. Our investors are interested to know about the rate of growth as well as to understand issues related to forecasting the number of Starbucks locations in the future. And specifically, we are wondering when the number of stores will reach 37,000 locations. You see, there are currently 37,000 McDonald’s restaurants worldwide, and we have set a goal to reach that number by the year 2020. Do you think we can do it?

1. identify the initial value and the growth rate of your exponential model and explain what they mean in context of Starbucks Stores. Put your explanations in a text box.
2. How well does the exponential function compare to the data from the Starbucks Company Time Line? Answer in a short paragraph in a text box.
3. Use your exponential model to predict when Starbucks will match McDonald’s for the number of locations.

Could this be answered within excel + handwritten notes and thoroughly explained. Please and thank you

INTRODUCTION TO LINEAR CORRELATION AND REGRESSION ANALYSIS.

An economist with a major bank wants to learn, quantitatively, how much spending on luxury goods and services can be explained based on consumers’ perception about the current state of the economy and what do they expect in the near future (6 months ahead). Consumers, of all income and wealth classes, were surveyed. Every year, 1500 consumers were interviewed. The bank having all of the data from the 1500 consumers interviewed every year, computed the average level of consumer confidence (an index ranging from 0 to 100, 100 being absolutely optimistic) and computed the average dollar amount spent on luxuries annually. Below is the data shown for the last 24 years.

Date                X                     Y (in thousands of dollars)

1994                79.1                 55.6

1995                79                    54.8

1996                80.2                 55.4

1997                80.5                 55.9

1998                81.2                 56.4

1999                80.8                 57.3

2000                81.2                 57

2001                80.7                 57.5

2002                80.3                 56.9

2003                79.4                 55.8

2004                78.6                 56.1

2005                78.3                 55.7

2006                78.3                 55.7

2007                77.8                 55

2008                77.7                 54.4

2009                77.6                 54

2010                77.6                 56

2011                78.5                 56.7

2012                78.3                 56.3

2013                78.5                 57.2

2014                78.9                 57.8

2015                79.8                 58.7

2016                80.4                 59.3

2017                80.7                 59.9

Questions:

1. Do you think that measuring the level of optimism is a good predictor for trying to forecast future spending on luxury items? Explain why or why not.
2. How would you be able to improve on the model? You must provide a minimum of two specific ways to go about improving the model.
3. If the economist expects that, by year’s end, the average level of consumer confidence will hit 81.5 points, how much will be expected by consumers to spend on luxury items?

the table gives a total U.S expenditure for health services and supplies selected years from 2000 and projected to 2018.

year $(billion)

2000 1264

2002 1498

2004 1733

2006 1976

2008 2227

2010 2458

2012 2746

2014 3107

2016 3556

2018 4086

a. find an exponential function model to these data, with x equal to the number of years after 2000. b) use the model to estimate the U.S expenditure for health services and supplies in 2020.

2.The percent of boys age x or younger who have been seually active are given below.

Age cumulative percent seuual active girls cumulative percent sexual active boys

15 5.4 16.6

16 12.6 28.7

17 27.1 47.9

18 44.0 64.0

19 62.9 77.6

20 73.6 83.0

a). Creat a logarithmic function that model the data using an input equal to the age of the boys.

b) use the model to estimate the percent of boys age 17 or younger who have been seually active

c. compare the percent that are sexually active for the two genders, what do you conclude.

3). if $12000 is invested in an account that pays 8% interest, compounded quaterly, find the future value of this investment

a) after 2 year. b) after 10 years.

4).if $9000 is invested in an account that pays 8% interest, compounded quaterly . find the future value of this investment

a) after 0.5 year b)after 15 years

5. Grandparents decide to put a lump sum of money into a trust fund on their gtanddaughters 10th birthday so that she will have $1000000 on her 60th birthday. if the fund pays 11% compounded monthly. how much money must they put in the account.

6.At the end of t years the future value of an investment of $25000 in an account that pays 12% compounded quaterly is

S=25000(1+0.12 /4t )^4t dollars.. a) How many years will the investment amount to $60000.

Because of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The following data show the enrollment (in thousands) for Jefferson Community College for the nine most recent years.

Click on the datafile logo to reference the data.

SUBJECT: TAXATION OF INDIVIDUALS AND BUSINESS ENTITIES (Chapter 25)

Required information

Roland had a taxable estate of $5.5 milionwhen he died this year.

Calculate the amount of estate tax due (if any) under the following alternative. (Refer to EXHIBIT 25-1 AND EXHIBIT 25-2).

a. Roland's prior taxable gifts consist of a taxable gift of $1 million in 2005. Estate tax due?

b. Roland's prior taxable gifts consist of a taxable gift of $1.5 million in 2005. Estate tax due?

c. Roland made a $1 million taxable gift in the year prior to his death. Estate tax due?

EXHIBIT 25-1

EXHIBIT 25-2 THE EXEMPTION EQUIVALENT

Please show the solution. Thank you

Use the data and Excel to answer this question. It contains the United States Census Bureau’s estimates for World Population from 1950 to 2014. You will find a column of dates and a column of data on the World Population for these years. Generate the time variable t. Then run a regression with the Population data as a dependent variable and time as the dependent variable. Have Excel report the residuals.

(a) Based on the ANOVA table and t-statistics, does the regression appear significant?

(b) Calculate the Durbin-Watson Test statistic. Is there a serial correlation problem with the data? Explain.

(d) What affect might your answer in part (b) have on your conclusions in part (a)?

Thanks id advance! Will try to rate the answer ASAP. Please show your process too :)

NOTE THAT

((This should be done by R studio !))

Q: Upload your data as a CSV in R studio, then do any
cleaning or convert needed for example convert the date in your table
from character to date and NA identifiers . After do all these, run a summary statistics

R ONLY !!

Consider a particle moving in two spatial dimensions, subject to the following potential:
V (x, y) = (
0, 0 ≤ x ≤ L & 0 ≤ y ≤ H
∞, otherwise.
(a) Write down the time-independent Schr¨odinger equation for this case, and motivate
its form. (2)
(b) Let k
2 = 2mE/~
2 and rewrite this equation in a simpler form. (2)
(c) Use the method of separation of variables and assume that ψ(x, y) = X(x)Y (y).
Rewrite the equation in terms of X and Y . (2)
(d) Divide by XY and solve for X00/X.
(e) Define a separation constant λ and write down the general solution for X(x). (2)
(f) Apply the boundary conditions in the x-dimension and obtain Xn(x). (4)
(g) Write down the general solution for Y (y). (2)
(h) Apply the boundary conditions in the y-dimension and obtain Ym(x). (3)
(i) Normalise ψnm(x, y). Make use of the fact that x and y are independent and that
the two integrals may thus be solved independently. (2)
(j) From the definition of k and using λ, obtain the discrete energies Enm. If we
define Enm ≡ Ex + Ey, write down expressions for the latter two terms

During 2003, General Motors cut the prices of its car models. As a result, GM earned a profit of only $184 per car, compared to the profit of $555 per car it had earned in 2002. Does the decline in GM’s profits per car indicate that cutting prices was not a profit-maximizing strategy? Briefly explain.