Why do you expect to see seasonality in sales of shampoo

Assignment Help Database Management System
Reference no: EM131925052

Problem

Shampoo Sales. The file ShampooSales.csv contains data on the monthly sales of a certain shampoo over a 3-year period. Source: Hyndman, R.J., Time Series Data Library.

a. Create a well-formatted time plot of the data.

b. Which of the four components (level, trend, seasonality, noise) seem to be present in this series?

c. Do you expect to see seasonality in sales of shampoo? Why?

d. If the goal is forecasting sales in future months, which of the following steps should be taken?

• Partition the data into training and validation sets

• Tweak the model parameters to obtain good fit to the validation data

• Look at MAPE and RMSE values for the training set

• Look at MAPE and RMSE values for the validation set.

Reference no: EM131925052

Questions Cloud

Write new server and client programs and probe and sampler : Write new server and client programs, Probe and Sampler, that use our Server and Client classes, respectively.
Calculate the new beps if it were possible to raise : The text shows how to compute the break-even point in units; sometimes it's also useful to know the break-even point in dollars (sales).
What is the overall error for the validation set : What is the overall error for the validation set? What is the percent improvement relative to the naive rule (using the validation set)?
Find the weighted average cost of this capital : Company A agrees to lend $300,000 and they require 5% interest, Company B will lend $200,000 at 6% interest, and Company C will loan the balance.
Why do you expect to see seasonality in sales of shampoo : Why do you expect to see seasonality in sales of shampoo? Why? If the goal is forecasting sales in future months, which of the following steps should be taken?
How has ibms stock been doing currently : Select "Investors" (US) on the next page on the right side. Select "Financial Snapshot" on the next page.
What is the value of a put option with strike price : IBM stock currently sells for 84 dollars per share. Over 8 months the price will either go up by 7.5 percent or down by -3.0 percent.
Prepare a well-formatted time plot of the data : Prepare a well-formatted time plot of the data. Comparing the two-time plots, what can be said about the type of trend in the data?
Calculate on a portfolio basis instead of a per-share basis : If you invest in the fund, what is your expected annual percent return net of the interest costs?

Reviews

Write a Review

Database Management System Questions & Answers

  Explain knowledge discovery database and give its components

Explain the knowledge discovery database and give its components. What are the market drivers of big data,give its challenges and advantages.

  Debugging the speed issue

A controller action is taking 10 seconds to run. Most of the time is being spent in a view which is a large file.(1000 lines). How will you go about debugging the speed issue?

  Give a list of employee names

Using the Northwind database - Give a list of employee names and each employee's corresponding customers by company name.

  Evaluate the role of conceptual modeling

Database Systems and Administration - (ECM38IS) - Evaluate the role of conceptual modeling in the development of database systems and apply the entity-relationship modeling approach to a realistic scenario

  Create a new manager class

Create a new package called task04. Copy your classes from package task03 into this package. Create a new class: Manager class.

  The cio asks you to describe why you believe it is

you are the information security officer at a medium-sized company 1500 employees. the cio asks you to explain why you

  Design a database solution and the potential business rules

Identify the potential sales and department store transactions that can be stored within the database. Design a database solution and the potential business rules that could be used to house the sales transactions of the department store.

  How do these change with variation in the condence values

Looking at the predictive accuracy (Percent correct) results for tree learning on these data sets, has learning improved accuracy over the baseline ?

  Determine what type of database they are

You are the Database Administrator for "Data R Us" and you have been asked to research a set of online databases and determine what type of database they are; based of the four explanations of the DBMS above

  Find the oldest person in the data

Using the attached data previously provided to you, do the following tasks as separate SQLs. Remove visits from dead patients and count distinct number of remaining patients. Find the oldest person in the data. Remove patients with less than 365 day..

  Modify the database by adding an additional column

Modify the database by adding an additional column ("Deleted_Date") to those tables that represent entities that could contain data which can be deleted and justify your rationale in a short paragraph.

  Discuss the importance of a procedural lifecycle

Create, and enter into the spreadsheet, a set of fictitious values that will suggest a return on investment for the new system within the next two years - Discuss why each of these components is important in the development of a new system.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd