Use Excel's regression function to develop a multiple regression forecast for Pricilla Phashions Indicate the r² of the model, and whether all the coefficients for the regression are significant, then calculate the dress sales for Year-3.show steps on excel During year three, Pricilla starting collecting data on why people were buying dresses. She and the people working inthe store would ask whether the purchase was for an event (homecoming, party, prom, or wedding. You noticed thatsells were higher in warmer months and decided to use average month temperatures. Also, you decided the separateweddings from other events. The following is a breakdown of the data.Wedding Events re1020012452320102118546S24222HRNE78 75 60 45 35202032AverageMonthlyTemperatu506032304250557075Year 3 Demand2122452523767574043543243386183567134949Using the dress data above, calculate the following

Wedding Events Average Monthly Temperature Year 3 Demand 2 1 32 212 0 0 30 245 0 5 42 252 12 22 50 376 45 46 55 757 23 22 70 404 20 20 75 354 10 20 78 324 2 32 75 338 1 50 60 618 1 22 45 356 8 60 35 713 4949

Answered: During year three, Pricilla starting…

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Related questions

Question

Use Excel's regression function to develop a multiple regression forecast for Pricilla Phashions Indicate the r² of the model, and whether all the coefficients for the regression are significant, then calculate the dress sales for Year-3.

show steps on excel

During year three, Pricilla starting collecting data on why people were buying dresses. She and the people working in
the store would ask whether the purchase was for an event (homecoming, party, prom, or wedding. You noticed that
sells were higher in warmer months and decided to use average month temperatures. Also, you decided the separate
weddings from other events. The following is a breakdown of the data.
Wedding Events re
1
0
2
0
0
12
45
23
20
10
2
1
1
8
5
46
S24222HRNE
78 75 60 45 35
20
20
32
Average
Monthly
Temperatu
50
60
32
30
42
50
55
70
75
Year 3 Demand
212
245
252
376
757
404
354
324
338
618
356
713
4949
Using the dress data above, calculate the following

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.

Similar questions