Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Ryerson excel download

17/04/2021 Client: muhammad11 Deadline: 2 Day

Exercise 1 You will be using very sophisticated forecasting software in this course. This software is used widely by organizations in the United States and abroad. You should visit johngalt.com to learn about the company whose software you will be using. Take a few minutes to look through their site, especially the references, company and support tabs. You will use the attached Amazon excel data for all of the exercises in which you will apply various forecasting methods. I have selected Amazon because the company has been in the news recently and I think it will be in the news for the eight weeks of this course. Amazon’s fiscal year begins in January and ends in December (see: https://www.google.com/search?client=firefox-b-1d&channel=cus&q=amazon+company+fiscal+year). For Exercise 1 there two parts. Your results should be submitted in a two (2) page Word document.1 Use 12 pt Times New Roman for all submissions in MKT555. For names in headers use single spacing but for the content use 1.5 line spacing unless told otherwise. In Amazon data files for dates we will use the middle month of each quarter to represent each quarter. Thus, February will represent the first quarter, May the second quarter, August the third quarter and November the fourth quarter. Exercise 1 Page One (for this you need only Excel): 1) In Excel prepare a time-series line graph of the of the Amazon sales revenue. Use only the16 quarters of 2015 through 2018. Go to “Insert” then select “Line Graph.” Paste the graph into Word. This should be prepared in as professional a manner as you can make it and should be as easily read as possible. Make sure that your graph has a meaningful and clear title. Below your graph indicate two forecast methods that you think might be appropriate for these data based on Table 2.1 of your forecasting text. For each method you mention give a short explanation of why you think that method could be appropriate. At this point the 1 When you have items to submit that have multiple pages be sure that you number pages. 1 selection is based only on the information in Table 2.1. As the term progresses you are likely to rethink the selections. Page 2 (for this you will need the current version of ForecastX). By now you should have already installed the software: https://details.johngalt.com/support/download/ Note: Sometimes when one clicks on this link it takes them to email. I have no idea why this can happen. If this happens to you copy the link and paste it into the address bar of your browser. Sign in using the following: username: fxstudent password: fx8wizedu#s 2) With the data file open place your cursor in cell B4, click on ADD-INS, then click on the blue “Forecast” icon right under the word FILE in Excel. A dialog box appears that 2 has the following main tabs: Data Capture, Forecast Method, Grouping (a tab we will not use), Statistics, and Reports. Note that, in the dialog box that first appears, ForecastX has correctly identified that the data are in columns and contain dates. Look at the dialog box for “Periodicity.” Check the periodicity and if it is not quarterly use the drop down menu to select quarterly. Make sure that under “Labels” there is a 1. This indicates that ForecastX sees one row of labels, which is correct for this file. At the top right you see a box for “Seasonality.” Use the up arrow to indicate 4, because the data are quarterly. In the box for “Forecast Periods,” indicate 8. Now you are ready to make a forecast. For this first exercise, we have not discussed any methods. Therefore, we will let ForecastX select a method based on the software’s review of the data series. To do this, in the “Forecast Method” tab under “Forecast Technique” use the drop down menu to select Procast and under Parameters select only MAPE. MAPE stands for Mean Absolute Percentage Error which is the error measure we will focus on. MAPE is the most widely used error measure in business applications. In the Statistics tab uncheck everything except MAPE. In the Reports tab check Audit. Have no other selections checked for this exercise. Then click on Finish. This will generate an automated forecast for this short series of A&F sales. At the top of your output there is a graph. Edit the numbers along vertical axis of the graph so that there are zero decimal places (usually those decimal places are not useful). Also, select “Currency” for the Category so that the data are shown to be in $. Edit the graph to change the line for the actual historic data to a (square) dotted blue line that has a 1.5 pt width. Then change the fitted values (these are values predicted by the model in the historic period) line to be a green, dashed line also with a 1.5 pt width. 3 Change the line representing the forecast values to a red (round) dotted line with a 2 pt width. Sometimes a fourth series shows up in the legend. If so, delete it from the legend. (It is not clear to my why this extra series sometimes shows up in a legend. Watch for this and delete when necessary.) Edit the title for the graph to read “Amazon Net Sales ($000,000).” Change the font for the title to Times New Roman 14 pt, do not use a bold font and remove underlining. This will give you a start on (or practice with) how to edit graphs in Excel. After your editing, copy the graph and paste it into the top of page two of your Word document.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Peter O.
Assignments Hut
Calculation Master
Solutions Store
Homework Guru
A Grade Exams
Writer Writer Name Offer Chat
Peter O.

ONLINE

Peter O.

I have read and understood all your initial requirements, and I am very professional in this task.

$29 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$32 Chat With Writer
Calculation Master

ONLINE

Calculation Master

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$39 Chat With Writer
Solutions Store

ONLINE

Solutions Store

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$31 Chat With Writer
Homework Guru

ONLINE

Homework Guru

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$29 Chat With Writer
A Grade Exams

ONLINE

A Grade Exams

Give me a chance, i will do this with my best efforts

$43 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Holy cross application form - Space frame design software - A primer on communication studies v 1.0 author - Criminology the core 4th edition study guide - Identifying an unknown hydrogen carbonate lab answers - Exit report in testing - Liberty by julia alvarez theme - Preparation of esters experiment grade 12 answers - Criteria for weighted scoring model - Cyberattack-Malware - Work -13 - Macquarie winton global alpha fund - Devices in persuasive writing - Pearson funeral home in emporia virginia - K3 creative center humble tx - Origin of life worksheet - Nanutarra roadhouse to minilya roadhouse - Iba data acquisition system - The way cowley uses the phrase "my own country" is an example of - Wgu c229 time log obesity - Paper-1 - English 101 Essay 3 PG about - Interpreting intraclass correlation coefficient spss - Lexical analyzer code in java - Discover academic excellence with SpeedyPaper.com - Isolated radium in 1910 - Enron the smartest guys in the room summary - Assignment 250 words - Bonnie raingruber health promotion theories - Pros of Using Free Essay Samples Paperwall101 - Harvard change management simulation tips - Newham business rates relief - Pennant hills day endoscopy centre - A3 vs a1 paper size - Marketing - Brazer cutters solderers welder typical entry level education - Essentials of business communication 11th edition pdf free - Customer value hierarchy model - Critical analysis of the floods by john ruganda - 2 nephi 15 20 - ADRP Instructions - Examples of fractured fairy tales - Jsp 800 vol 5 - Wireshark dns lab solutions - Falmouth figure skating club - Lucifer lighting price list - Phoenix MGT 426 Selecting a Company - 19-21 ashley avenue hoppers crossing - How do information systems eliminate the problems of information silos - Performance Appraisal System - Interval between sections of a play - Financial reporting in the catholic church case study - Know your rights group australia - The monomer used to make pvc is - Social psychology definition paper psy 400 - Decisions by Manager - Need Response 2 to below discussion-cost - How to address a congressperson in a letter - Tutor account on sale - Dignitas latin translation stage 30 - Gucci target - The big mower coolalinga - HW - The implications of tawhid for muslim belief - Copper chloride dihydrate and aluminum - Assignment - Cisco finesse not ready reason codes - Literature Search, Rapid Critical Appraisal, and Summary - Market potential inde - Bec vantage speaking topics - Yachuk v oliver blais - Research paper - EDU - Advanced life support flow chart - Understanding the difference between a discriminative stimulus - Clearance in heat exchanger - The leadership gap lolly daskal pdf - Annotated Bibliography URGENT DUE 9/6/20 NO LATER THAN 6PM - Rep 1 - Uses of infrared radiation in physiotherapy - Minimum wage interest groups - Driving miss norma discussion questions - Bbc schools nursery rhymes - Api 670 overspeed protection - Sas proc freq example - Https newconnect mheducation com flow connect html answers - True and false - Hager serie golf ip41 - Structural functionalism talcott parsons - Erosion of niagra falls - Name three stains that can be used for negative staining - Multiple choice questions on leadership and management - Http applications marykayintouch com community default aspx - Lady james hall irlam - Red bull case analysis - The securities and exchange commission outlaws: - 3 discussions due in 4 DAYS - Order 2379643: Curriculum Development - Jk rowling harvard speech rhetorical analysis - Los turistas llegaron hace una semana. la guía turística les da la bienvenida.