Despite the growth in digital entertainment, the nation’s 400 amusement parks have managed to hold on to visitors. A manager collects data on the number of visitors (in millions) to amusement parks in the United States. A portion of the data is shown in the accompanying table.

SOURCE: International Association of Amusement Parks and Attractions.
Click here for the Excel Data File

a. Estimate the linear trend model to make forecasts for 2008. (Round your answers to 2 decimal places.)

yˆ =

b. Estimate the exponential trend model to make forecasts for 2008. (Round your answers to 2 decimal places.)

yˆ =

Can you provide solution in the Excel using Solver for the below problem ?

On Monday morning, you have $3000 in cash on hand. For the next seven days, the following cash requirements must be met: Monday, $5000; Tuesday, $6000; Wednesday, $9000; Thursday, $2000; Friday, $7000; Saturday, $2000; Sunday, $3000. At the beginning of each day, you must decide how much money (if any) to withdraw from the bank. It costs $10 to make a withdrawal of any size. You believe that the opportunity cost of having $1 of cash on hand for a year is $0.20. Assume that opportunity costs are incurred on each day’s ending balance ($0.20/365). Determine how much money you should withdraw from the bank during each of the next seven days.

For developing countries in Africa and the Americas, let p₁ and p₂ be the respectiveproportions of babies with a low birth weight (below 2500 grams). A randomsample of n₁ = 2000 African women yielded y₁ = 750 with nutritional anemia anda random sample of n₂ = 2000 women from the Americas yielded y₂ = 650 womenwith nutritional anemia. We shall test H₀: p₁ = p₂ against the alternative hypothesisH₁: p₁ > p₂ at α = 0.05.

1. What is the type of the test?

a) Right-tailed

b) Left-tailed

c) Two-tailed

2. Calculate Observed Test Statistic

3. Find the P-value of the test

4.Find the Critical Value of Critical Region of the Test

5. Draw Your Conclusion of the Test at α = 0.05

a) Fail to Reject H0

b) Reject H0

1. Using the following lines of data, create a temporary SAS data set called ThreeDates. Each line of data contains three dates, the first two in the form mm/dd/yyyy descenders and the last in the form ddmmmyyyy. Name the three date variables Date1, Date2, and Date3. Format all three using the MMDDYY10. format. Include in your data set the number of years from Date1 to Date2 (Year12) and the number of years from Date2 to Date3 (Year23). Round these values to the nearest year. Here are the lines of data (note that the columns do not line up):

01/03/1950 01/03/1960 03Jan1970

05/15/2000   05/15/2002   15May2003

10/10/1998 11/12/2000    25Dec2005

Write a class Battery that models a rechargeable battery. A battery has a constructor

public Battery(double capacity)

where capacity is a value measured in milliampere hours. A typical AA battery has a capacity of 2000 to 3000 mAh. The method

public void drain(double amount)

drains the capacity of the battery by the given amount. The method

public void charge()

charges the battery to its original capacity.

The method

public double getRemainingCapacity()

gets the remaining capacity of the battery.

Supply a Battery class that tests all methods. Make sure to print the remaining capacity.

If we create an instance of Battery class with 2000 mAh, call drain (500) and then call getRemainingCapacity(), it should print 1500mAh; now if we call charge() and then call getRemainingCapacity() it should print 2000mAh

Annual high temperatures in a certain location have been tracked for several years. Let X represent the number of years after 2000 and Y the high temperature. Based on the data shown below, calculate the linear regression equation using technology (each constant to 2 decimal places). x y 3 35.01 4 35.38 5 37.75 6 36.12 7 36.49 8 40.16 9 38.93 10 39.7 11 42.77 12 43.24 13 42.11 14 44.08 The equation is ˆ y = x + Interpret the y-intercept of the equation: In 2003, the temperature was about 0.84. It does not make sense to interpret the intercept in this scenario. In 2014, the temperature was about 44.08. In 2003, the temperature was about 32.17. In 2000, the temperature was about 32.17

According to a​ publication, 12.3​% of 18 to 25 dash year dash olds were users of marijuana in 2000. A recent poll of 1293 randomly selected 18 to 25 dash year dash olds revealed that 176 currently use marijuana. At the 5​% significance​ level, do the data provide sufficient evidence to conclude that the percentage of 18 to 25 dash year dash olds who currently use marijuana has changed from the 2000 percentage of 12.3​%? Use the​ one-proportion z-test to perform the appropriate hypothesis​ test, after checking the conditions for the procedure. What are the hypotheses for the​ one-proportion z-test? Upper H 0​: pequals nothing​; Upper H Subscript a​: p ▼ greater than not equals less than nothing ​(Type integers or​ decimals.)

Consider the following realized annual returns:

1. 2005	-11.3%	52.7%
   2006	-20.8%	-22.0%
   2007	33.1%	6.9%
   2008	13.0%	9.2%
   2009	7.3%	-0.9%

2. Consider the following realized annual returns:
   
   
   
   
   
   
   
   
   

3. Q1 : Suppose that you want to use the 10 year historical average return on the Market to forecast the expected future return on the Market. Calculate the 95% confidence interval for your estimate of the expect return. Q2 : Using the data provided in the table, calculate the average annual return, the variance of the annual returns, and the standard deviation of the average returns for Stock B from 2000 to 2009.

    Table Name: CUSTOMERS_1

CUST_NUM CUST_LNAME          CUST_FNAME          CUST_BAL

2001    James William           $2,999

2002    Crane Frasier             $983

    Table Name: CUSTOMERS_2

CUST_NUM

            CUST_LNAME          CUST_FNAME          CUST_BAL

1999    Anderson         Anne $510

2000    Bryant Juan     $21

2002    Crane Frasier             $983

2003    Dent    George            $1,790

    Table Name: CUST_INVOICES

INV_NUM     CUST_NUM INV_DATE    INV_AMOUNT

9000    2000    23-Mar-16       245

9001    2001    23-Mar-16       260

9002    2001    30-Mar-16       275

9003    1000    10-Apr-16       286

using this information, i need help formulating an sql query:

    Write a SQL code that will show CUST_NUM, CUST_LNAME, and CUST_FNAME for the one who has minimal INV_AMOUNT