Question

Please finish the following assignments in Excel and submit the Excel file onto Pilot. Please use...

Please finish the following assignments in Excel and submit the Excel file onto Pilot.

Please use the data in “GPS.XSLS” to:

  • Q1. Estimate the parameter p and q in Bass Model.
  • Q2. Compute the time and value of peak sales.
Year Sales (00s)
1990 164
1991 276
1992 578
1993 1604
1994 3435
1995 5785
1996 8500
1997 12000
1998 15000
1999 18000
2000 20000
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

solution:

please give me thumb up

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following data contains monthly U.S. domestic air miles traveled during the years 1970-2004 , determine...
The following data contains monthly U.S. domestic air miles traveled during the years 1970-2004 , determine the trend and seasonality for the years 1995-2004 and Try both additive and multiplicative models and for the multiplicative model, use only one constraint: the average of seasonal indices set to 1 Year Month DATA 1970 1 9764490 1970 2 8163943 1970 3 9875362 1970 4 9289053 1970 5 10029494 1970 6 11821707 1970 7 12630952 1970 8 13495546 1970 9 10283314 1970 10...
(Inflation)Here are some recent data on the U.S. consumer price index:             Year     CPI            &
(Inflation)Here are some recent data on the U.S. consumer price index:             Year     CPI                  Year     CPI                  Year     CPI                  Year     CPI             1988     118.3                1993     144.5                1998     163.0                2003     184.0             1989     124.0                1994     148.2                1999     166.6             1990     130.7                1995     152.4                2000     172.2             1991     136.2                1996     156.9                2001     176.9             1992     140.3                1997     160.5                2002     179.9 Compute the inflation rate for each year 1989-2003 and determine which years were years of inflation.  In which years did deflation occur?  In which years did disinflation occur?  Was there hyperinflation in any year?
In Java: Write a program that displays all the cars in the given file (no sorting)....
In Java: Write a program that displays all the cars in the given file (no sorting). Each car property is separated by a tab character: \t Output width: 15 (make), 25 (model), 5 (year) Given cars.txt : make   model   year Ford   Expedition   2003 Mazda   B-Series   1989 Ford   Freestar   2003 Hyundai   Elantra   2001 Hyundai   Entourage   2008 Chevrolet   Camaro   2011 Chevrolet   Monte Carlo   2006 Chevrolet   Blazer   1996 Chevrolet   Aveo   2005 Chevrolet   Corvette   1999 Mercedes-Benz   E-Class   2006 Dodge   Avenger   1995 Pontiac   Grand Prix  ...
While Florida obviously has the upper hand in terms of production, California claims that they have...
While Florida obviously has the upper hand in terms of production, California claims that they have the upper hand in terms of productivity. test this hypothesis Year CALIFORNIA FLORIDA 1978 226 290 1979 199 287 1980 320 358 1981 357 301 1982 233 225 1983 429 260 1984 274 246 1985 299 247 1986 309 324 1987 335 319 1988 342 363 1989 332 377 1990 408 276 1991 143 360 1992 371 315 1993 363 381 1994 344 341...
A. Use the three- and seven-term moving averages to generate one-step ahead forecasts for 1981 to...
A. Use the three- and seven-term moving averages to generate one-step ahead forecasts for 1981 to the end of the series. Graph the results, and comment on the difference between the two moving averages. B. Compare the performance of the two procedures by calculating the RMSE and MAE. Why is Mape inappropriate in this case? Please show to do this in excel, I am having a difficult time understanding how this is done. Year GDP Growth 1963 4.4 1964 5.8...
1. It has been suggested that global warming may increase the frequency of hurricanes. The table...
1. It has been suggested that global warming may increase the frequency of hurricanes. The table given below shows the number of major Atlantic hurricanes recorded annually before and after 1990. before 1995 after 1995 year # of storms year # of storms 1976 2 1996 6 1977 1 1997 1 1978 2 1998 3 1979 2 1999 5 1980 2 2000 3 1981 3 2001 4 1982 1 2002 2 1983 1 2003 3 1984 1 2004 6 1985...
Year       Diagnosed       Deaths 1981       319                    &
Year       Diagnosed       Deaths 1981       319                         121 1982       1170                       453 1983       3076                       1482 1984       6240                       3466 1985       11776                    6878 1986       19032                    11987 1987       28564                    16162 1988       35447                    20868 1989       42674                    27591 1990       48634                    31335 1991       59660                    36560 1992       78530                    41055 1993       78834                    44730 1994       71874                    49095 1995       68505                    49456 1996       59347                    38510 1997       47149                    20736 1998       38393                    19005 1999       25174                    18454 2000       25522   ...
When will the world reach zero growth rate? 1964 5.068 1965 5.05     1966 4.997 2007...
When will the world reach zero growth rate? 1964 5.068 1965 5.05     1966 4.997 2007 2.553 1967 4.974 2008 2.542 1968 4.92 2009 2.524 1969 4.85 2010 2.508 1970 4.771 2011 2.492 1971 4.662 2012 2.484 1972 4.533 2013 2.468 1973 4.405 2014 2.461 1974 4.285 2015 2.452 1975 4.155 2016 2.439 1976 4.041 1977 3.94 1978 3.849 1979 3.781 1980 3.722 1981 3.666 1982 3.637 1983 3.603 1984 3.572 1985 3.542 1986 3.505 1987 3.461 1988 3.406 1989...
Perform a hypothesis testing using Kendall’s Tau method to check if the distribution of peak flows...
Perform a hypothesis testing using Kendall’s Tau method to check if the distribution of peak flows does not change as a function of time. Data is below please show step by step. I will rate afterwards. Year Peak Flow 1947 15500 1948 27400 1949 27500 1950 43000 1951 19100 1952 17600 1953 15800 1954 8600 1955 9950 1956 35400 1957 34700 1958 37000 1959 26000 1960 27000 1961 42300 1962 26300 1963 41600 1964 50500 1965 15500 1966 6710 1967...
The data set below contains the average yearly retail gasoline prices​ (cents/gallon) from 1990 to​ 2007,...
The data set below contains the average yearly retail gasoline prices​ (cents/gallon) from 1990 to​ 2007, from a regional sample of gasoline stations. Complete parts a through c. Full data set Year 1990 1991 1992 1993 1994 1995 1996 1997 1998 Price 9090 102102 112112 119119 123123 107107 9999 103103 9797 Year 1999 2000 2001 2002 2003 2004 2005 2006 2007 Price 115115 133133 153153 141141 191191 201201 190190 247247 285285 ​a) Create a histogram of the data and describe...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT