logo Hurry, Grab up to 30% discount on the entire course
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Cody GutierrezEngineering
(5/5)

518 Answers

Hire Me
expert
Jason RoyComputer science
(5/5)

525 Answers

Hire Me
expert
Justice CookResume writing
(5/5)

821 Answers

Hire Me
expert
Harjinder SinghHistory
(5/5)

506 Answers

Hire Me
Excel
(5/5)

What type of time series is each of your plots? Explain why you feel they follow that type of time series. Is there a trend?

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Project 1

1. For this project, you are going to focus on analyzing time series. Here are the steps you will need to take to complete this project. I suggest reading through these steps fully before beginning your project to make sure you understand everything that is required:

a. You need to find data sets with a time variable and at least one variable that you can analyze over time. For example, think of a data set with home prices. You could analyze the price of the homes over time if you are given the day, month, year, etc. However, it would not make as much sense to plot something such as number of bedrooms or bathrooms over time, as these don’t really make sense as a variable that might change over time. Think carefully when looking for data sets about something that you might be interested in analyzing over time. Each data set needs to include at least fifteen rows of data.

b. You will need five separate data sets that match the criteria in part a: they need a time component and a variable that makes sense to analyze over time.

c. You must provide me with a source for where you found each data set by providing the links in the project document. You can use websites such as statcrunch (click data sets on the home screen; if you find a data set that works, you can click ctrl+a to highlight it all, click ctrl+c to copy it and then paste it into an excel sheet using ctrl+v-you do NOT need to purchase anything to use the data sets on this website), Kaggle, or any other reliable source.

d. Please put all of your data sets in Excel with each one on its own individual sheet.

e. You need to plot each of the time series in a line plot.

f. What type of time series is each of your plots? Explain why you feel they follow that type of time series. Is there a trend? Seasonality? Is it random? What may be influencing those factors?

g. For each of the data sets, do not include the last three rows of data in the next steps. We will use these to compare to your predictions. Cut them out and paste them lower in the Excel sheet.

h. For three of your time series, please use a three-period moving average and forecast the next three values in the time series. Compare this is the three values you did not include. Does the three-period moving average forecast these time series accurately?

i. For the fourth and fifth time series, use simple linear regression with the time component as an input variable and forecast the next three values in the time series. Is the time component significant? Compare this to the three values you did not include. Does your prediction with regression forecast these time series accurately?

j. Please create a word document with one section for each time series. Each section should include the link to the data set for that section, screenshots of the plots, screenshots of the forecasting, and all analysis done. Please also submit your Excel file.

k. Any indication of sharing data sets or cheating will result in both students receiving a zero on this project. Please find your own data and do your own interpretations.

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme