Question: Part A. Your first task is to calculate the Slope for the Linear Regression line based on the above data. What is the value of

Part A. Your first task is to calculate the Slope

Part A. Your first task is to calculate the Slope for the Linear Regression line based on the above data. What is the value of the Slope given the past data? If your answer is not an integer, provide at least three decimal places, e.g., 7.500.

Part B. Your second task is to calculate the Intercept for the Linear Regression line based on the above data. What is the value of the Intercept given the past data? If your answer is not an integer, provide at least three decimal places, e.g., 7.500.

Part C. Based on the slope, intercept, and the given data, what is the Average Seasonal Index for the Summer season? You DO NOT need to calculate the average SI for the other seasons. If your answer is not an integer, provide at least three decimal places, e.g., 7.500.

Part D. What is your final demand forecast for Summer 2022 (Period 9)? You need to calculate the regression output for this period and then adjust for seasonality using the average SI. If your answer is not an integer, provide at least three decimal places, e.g., 7.500.

Problem 3: Beach Palace As the manager of Beach Palace, a beach resort in Cancn, you need to forecast demand for rooms in Summer 2022 (Period 9) based on the given data. (Assume that the resort has only one kind of room. Please ignore the impact of Covid -19.) Period 1 2 Season Summer 2020 Fall 2020 Winter 2020 Spring 2021 Summer 2021 Fall 2021 Winter 2021 Spring 2022 3 4 5 6 Demand for rooms 150 120 85 115 135 105 72 95 7 8 Since there is trend and seasonality in the data, you have opted for Linear Regression with Seasonal Indices as your preferred forecasting technique

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Valuing an Entity to Shareholders with Buy-Manage-Sell Model Introduction Company ZED is a profitable, operating in steady state forever Despite this, the economy is in recession, which has depressed...

ABC Company reports their earnings and expenses data from the years 2004 to 2018 as shown in the table. Use Linear Forecasting and regression to calculate the expense value in the year 2021. 8 9...

i need help with how to insert it as an excel format, thank you. CAPM \& Stock Valuation Project The estimation of company betas is normally brushed over in many introductory finance texts. This...

Only need to answer 6,7 and 8 Part I: Beta and Returns Estimation The estimation of betas for firms is normally brushed over in many introductory finance texts. This often leads students to view beta...

help this lab is due soon and I don't know what to do Problem 2: you need to write a function that accepts two lists of numbers of same lenght (representing, independent and dependent variables x and...

Please show the equation used in Excel or how you did it (you do not have to show the actual number answer if it's the same excel function), please and thank you! First download into Excel the...

In order to receive credit for your answers, use Excel Financial Functions or Excel Cell Formulas to answer these questions in your spreadsheet. Part I: Beta and Returns Estimation The estimation of...

please do full thing in excel and make doc accessible! Safari File Edit View History Bookmarks Window Help C $ 7% Tue 3:56 PM Q DE . . . A compass2g.illinois.edu C O CAPM Stock Valuation.....

This is Crystal Violet Lab Please help me on 1,2,3,4,5 Here is the information: 1. Was the reaction zero, first, or second order, with respect to the concentration of crystal violet? Explain. 2....

Refer to the Excel Projects Guidelines file in the Group Corner folder. CAPM & Stock Valuation Project The estimation of company betas is normally brushed over in many introductory finance texts....

Answer the Following Questions. 1. First download into Excel the AT&T (T), Nvidia (NVDA), and S&P 500 Stock Index (GSPC) Monthly Price data for the 5-Year Period from March 1, 2013 to February 28,...

e-considers investing into two stocks which are listed on the All Pacific Islands Stock Exchange (APIX). He thinks that Pacifict (stock C) and Casinos (stock D) are particularly promising...

If profit after tax for the year ended June 30, 2021 is $520,000, transfer to general reserves is $43.000, 50,000 ordinary shares were issued at $2.50 each, and preference share dividend is to be...

What type of inventory is one of the most damaging from a sustainability perspective? Group of answer choices Landfill Raw materials Finished goods Work in process

26.Imagine that a local public high school decided that they wanted to put all the boys in one chemistry class and all the girls in another chemistry class. My son wanted to be in the girls chemistry...