# INTS 4710-2 Spring 2023 Assignment 2

__________________________________________________________________________________________

You want to predict monthly Gas Prices in Colorado from May 2023 to April 2024. You need to do this using Excel (Question 1) and Stata (Question 2), based on the given instructions.

Please create new columns and cells in this data file (in Excel). You must create new columns containing formulas to calculate the Average of all seasons, Average of averages, Seasonal Factor, Deseasonalized Price and Reseasonalized Price, and any additional columns you may need. You will also have to create a few more additional cells (not entire columns) containing some formulas. All your new columns and cells must contain only formulas (except for the column names), i.e., when I double-click on any of these cells, I must be able to see the underlying Excel formula and not a number/value. Save this completed Excel file as Assignment_2.xlsx

• Once again, download the Gas Prices.xlsx file from the Assignment 2 link on Canvas. Then import this file (all 49 rows and 3 columns) into Stata using File…Import and then save this Stata data file as Assignment_2.dta (You can use the pwd command to see where this file has been saved on your laptop.)

Please write commands to create the following new columns in this Stata data file, based on the given information. For each column, the word before the colon must be assigned as the column name.

1. MA:  The (randomly chosen) October 2020 forecast should be the average of 2.277, 2.364, 2.435 and 2.271
2. WMA: The (randomly chosen) October 2020 forecast should assign 20% weight to 2.277 and 80% weight to 2.364
3. ES: α = 0.65; initial forecast is assumed to be the same as initial actual.
4. OVERALLAVG: Overall average of all DollarsPerGallon
5. SEASONALAVG: Average of each season
6. SF: Seasonal Factors
7. DSDPG: Deseasonalized DollarsPerGallon
8. REG1: Predicted linear regression values of the appropriate dependent variable based on Period
9. FINALDPG: Final predicted values of DollarsPerGallon using Time-Series Decomposition

Your final Stata data file must contain at least 12 columns (3 given, plus 9 created, plus any other columns you need to create). Once you have finished creating all these columns, and before closing out of Stata, make sure to select all commands (used to create all these new columns) in the History window and send these to a do-file editor. This do-file must then be saved as Assignment_2.do

Notes:

1. In both the Excel and Stata (columns number 4 through 9 above) questions, you need to forecast using the Time-Series Decomposition method, based on assuming each month as a different season.
2. Even though you have been given only the (randomly chosen) October 2020 forecast for Stata columns number 1 and 2 above, you should calculate all possible forecasts for Stata columns number 1 through 3.

Your deliverable for this assignment is:

1. Assignment_2.xlsx Excel file and Assignment_2.do do-file (to be submitted on Canvas at or before 9 a.m. on Thursday, May 18, 2023). Please do not submit your Assignment_2.dta file.

Get expert help for INTS 4710-2 Spring 2023 Assignment 2 and many more. 24X7 help, plag free solution. Order online now!

Universal Assignment (December 4, 2023) INTS 4710-2 Spring 2023 Assignment 2. Retrieved from https://universalassignment.com/ints-4710-2-spring-2023-assignment-2/.
"INTS 4710-2 Spring 2023 Assignment 2." Universal Assignment - December 4, 2023, https://universalassignment.com/ints-4710-2-spring-2023-assignment-2/
Universal Assignment May 22, 2023 INTS 4710-2 Spring 2023 Assignment 2., viewed December 4, 2023,<https://universalassignment.com/ints-4710-2-spring-2023-assignment-2/>
Universal Assignment - INTS 4710-2 Spring 2023 Assignment 2. [Internet]. [Accessed December 4, 2023]. Available from: https://universalassignment.com/ints-4710-2-spring-2023-assignment-2/
"INTS 4710-2 Spring 2023 Assignment 2." Universal Assignment - Accessed December 4, 2023. https://universalassignment.com/ints-4710-2-spring-2023-assignment-2/
"INTS 4710-2 Spring 2023 Assignment 2." Universal Assignment [Online]. Available: https://universalassignment.com/ints-4710-2-spring-2023-assignment-2/. [Accessed: December 4, 2023]

## Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

# Get 90%* Discount on Assignment Help

### Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as \$10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

### 5 Places you must visit in Busan, South Korea

Write 2 articles 1st Topic: 5 Places you must visit in Busan, South Korea 2nd topic: Korean language: various tips and resources to learn Deadline: 10th October 2023 12:00 AM Instructions: Article Structure is given below Meta Description: First, you will start with a meta description of your article in

### 2002HSV Human Services Research

Assessment 2: Written research proposal Worth 45% of final grade Complete your answers in this assignment template Name: xxxxxxx Student ID: xxxxxxx Title: xxxxxxx Exact word count (exc. cover sheets and reference list; max. 2,000 words): x,xxx Please specify the research methodology are you proposing to use: ☐ Quantitative                                    ☐

### COIT29226 Introduction to IoT

Assessment item 3 – Project Due date: Week 12 (8 October 2023) 11:55 pm AEST Weighting: Length: Submission: 50% There is no word limit for this report Group work (submit via Moodle) Objectives This assessment item relates to the following unit learning outcomes: Learning Outcomes Assessed: Enabling objectives What do

### BUSM1008 Assessment 2 Brief Spring 2023

Assessment 2: Individual Report (20%) and Presentation (20%) Background You are appointed as a business consultant, recruited by the company allocated to you in week 6 by your tutor.  Your role is to undertake research on the company, the allocated topic and an issue identified in the media in relation to your company and

### ECON1020 PRINCIPLES OF ECONOMICS

INDIVIDUAL ASSIGNMENT Total Marks 100 | Weighting 25% DUE: 29/09/2023, 11:55pm IMPORTANT INFORMATION: READ BEFORE YOU START SUBMISSION 11.55 pm. A 1-hour grace period is provided to students who experience a technical concern. DOCUMENT PREPARATION REFERENCING UNACCEPTABLE ACADEMIC ACTIVITIES MARKING Question 1 | [12 marks] Download the spreadsheet data that

### ENTERPRISE LAW LAWS1001

Assessment task 3 Individual Case Study This task is the result of your individual effort, so students must not discuss their work with anyone else, otherwise it may lead to an allegation of collusion. Weight: 15% Due: Before 5 pm on Wednesday 27th September. Late submissions will incur a penalty

Module International Business INBU01-7 (NQF LEVEL 7) FORMATIVE ASSESSMENT – ASSIGNMENT C Assignment C (INBU01-7/DLO4 10/2023) Exam Date 20 October 2023 Marks 50 Assignment C (INBU01-7/DLO4 10/2023)   Total: 20 marks SECTION A (10 MARKS) – PARAGRAPH QUESTION Question 1 (10 marks) Coca-Cola is marking its 70th year in Nigeria

### Summative Assessment Help

Summative Assessment Brief: Learning Outcomes: LO1: Construct a problem/issue/need identified from practice that impacts on individual outcomes LO2: Formulate a focus-based enquiry on the identified problem/issue/need utilising an area of individual learner interest LO3: Critically evaluate the evidence base to support the proposal of the solution focused initiative LO4: Develop

### EDU30067 Teaching English

Assignment 2: Folio Template INTRODUCTION:         LESSON 1 Lesson title:   Year level: Topic:   Duration of lesson: Curriculum links: Strands & sub-strands Content descriptions       Students background knowledge: What is your starting point – what do the students already know, what have they done

### Edge Computing Security and Privacy

Proposal Background Title: Edge Computing Security and Privacy Proposal The new computing paradigm in the Internet of Things domain is known as IoT edge computing which functions by processing calculations at the edge of the network (Alli & Alam, 2020). The current technology aided by cloud and fog computing has created

### Foundations of Communication Assessment 2 Instructions

Discussion task (Total grade – 10%)   Process Work (Steps to complete the task) Answer on the Assessment 2 Submission Document – Do not upload this instruction document. Requirements (important elements to include) lastname_firstname_studentID_COMS_Assess 2_semester_year. Process for Assessment discussion tasks NOTE: If you do not participate in the class discussions then

### Assessment Two Dos and Don’ts (Internal)

Do: Read the assessment instructions carefully Read the marking rubric carefully Understand the question – break it down Conduct research – record the reference details Read the topic materials about communication theories, forms and factors and refer to them Contribute to the discussions in class or no marks for the

### Unpacking the Question: Assessment Two

Studying at university requires you to become familiar with strategies to un-pack or breakdown a variety of assessment questions/tasks throughout your studies.  Task Example of integrating the discussion, research and theories. In the group discussion my group members (name them) stated that an advertisement for a beauty product would most

### MGMT0001 Introduction to Commerce Assessment

MGMT0001 Introduction to Commerce Assessment 2 (worth 30%) Due date:                  2:00pm (AWST) Friday 15th September 2023 Submission:              Via Turnitin assessment submission link (see ‘Assessment 2’ folder in ‘Assessments’ section of Blackboard). Additional Instructions: Part A (42 marks) Nathan is a well-known chef with years of experience cooking various cuisines. After

### ACCT5011: Accounting Systems in the Digital Age

Practical Assignment Guide, Semester 2, 2023 Due Date for Submission: Monday 11th September 2023 at 5.00 PM Please note that the Folio Assignment for ACCT5011 Accounting Systems in the Digital Age is an individual assessment task worth 30% of your total marks in the unit. Please refer to the online

### EC229- Review session

Assume two cities, A and B, that can’t trade between them. Each city produces its own coconuts for its local market. If suddenly trade is possible then: D) As we saw in class, the new price will be somewhere between the original price 𝑃_𝐴,𝑃_𝐵. Hence it is impossible for consumers

### Computing Theory COSC

Computing Theory COSC 1107/1105 Assignment 1: Fundamentals Assessment Type Individual assignment. Submit online via Canvas → As- signments → Assignment 1. Marks awarded for meeting re- quirements as closely as possible. Clarifications/updates may be made via announcements/relevant discussion forums. Due Date Week 6, Sunday 27th August 2023, 11:59pm Marks 125

### BE279 Applied Statistics and Forecasting

Strategy, Operations, & Entrepreneurship Group Essex Business School Module Code BE279 Module Title Applied Statistics and Forecasting Assessment Type Individual Report (2,000 word) Academic Year 2022/23, Spring Term Submission Deadline Refer to FASER Task Specific Guidance Please note that: Module Learning Outcomes On successful completion of the module, students will

### Learning Design Tool: Little Learners Level 1 sounds

Learning Design Tool: Little Learners Level 1 sounds. Prepared by Sara Hart Date 30th August, 2023 (feel free to leave this date as it is the AT2 due date) Brief description of Learning Design   Chooseit Maker: Create, edit and play personalised learning activities that can be used in your

### HUMN1041 PEOPLE, PLACE AND SOCIAL DIFFERENCE ASSIGNMENT

HUMN1041 PEOPLE, PLACE AND SOCIAL DIFFERENCE ASSIGNMENT 1 TEMPLATE This assignment is made up of three (3) parts, plus a reference list and appendix. Marks are allocated for each section, as follows: – 1 mark Please ensure that you provide your answers in this template, and provide a Reference list

### Model 3 Launch in Australia

Client Information Company Name Tesla Contact Name   Email   Phone Number   Address Level 14, 15 Blue St. North Sydney, NSW 2060 Australia Ad link & image Project Information Project Title Model 3 Launch in Australia Project Description (100 words) Highlight the uniqueness of the car. Show the superior

### MKT10009 Marketing and the Consumer Experience

School of Business, Law and Entrepreneurship Assessment Task – Assignment 2  MKT10009 Marketing and the Consumer Experience Semester 2, 2023. Assessment Type Analytical Report Associated Unit Learning Outcomes (ULO’s) 2, 3, 4 Group or Individual task Individual Value (%) 25% Due Date Monday 20th September at 10:00 AET – Enterthis

### ASSIGNMENT – 1st Evaluation

ASSIGNMENT – 1st Evaluation Date of Submission- 4TH SEP 2023 25 MARKS COMPARATIVE PUBLIC LAW Q. You are the new Central Minister for Urban Development who is keen to make major Indian cities as smart cities. You visit different countries like USA, UK, European Countries, Japan and other developed countries

### Corporate & Financial Due Diligence Report

[Name of the company] Note: Students should keep in mind that application of legal provisions (including Securities Regulations) and analysis of the same is important. Merely putting the facts and figures won’t fetch even a decent mark. Note: Students should only mention the broad area of business. This part should

### ECON1000 S2 2023 – Marking Guidance and FAQs on GTP

Students will be marked on the extent to which they specifically answer the question and provide clear, logical, well-reasoned and sufficient explanations. Here is a summary breakdown of how marks are allocated in this GTP: Part 1 [15 marks] §  Providing relevant observations from the information provided in the articles

### ECON1000 S2 2023 – GTP Brief

ECON1000 S2 2023 – GTP Brief A.  Context and Overview The Game Theory Presentation (GTP) is worth 30% of the final mark. GTP is a ‘take-home’ exercise with a set of tasks to do. The GTP is based on Lecture Topics: L1 and L2. You will have twenty (21) days

### Order #35042 Human Rights Research Essay

Draft due 26th Aug 2,500 words (excluding references and bibliography) Instructions: Structure: Title – The Tigray War: A Critical Analysis of What the Future Holds for Human Rights in the Region What can be done to ensure human rights violations will cease and be prosecuted? Expand on different actors and

### PMC1000: Applied Pathology

Assessment Task Sheet: Poster Presentation Date: Thursday 31st August 2023 | Weighting: 30% Assessment Task 2 You are required to develop a handout style resource (pamphlet or brochure) on a selected pathological condition which is aimed at first year student paramedics. You will need to use high quality peer reviewed

### Identify a current and topical public health ethical issue

Task Details You are required to identify a current and topical public health ethical issue in the workplace (if you work within a public health setting) or in a selected community and a plan of action to address the issue and submit it in Moodle as a Power Point presentation. The