b题财经商学院汪明慧

1、基升舱；价格稳定性；最大利润率；回归分析：软订舱位的价格，完善每次航行预订舱位价格表 sheet3。Excel模型，并计算第 8 次航行的预期售票收益。基升舱；价格稳定性；最大利润率；回归分析：软订舱位的价格，完善每次航行预订舱位价格表 sheet3。Excel模型，并计算第 8 次航行的预期售票收益。Thisraimsyze the mechanism of theeffect of thedifferent space different voyage of the price and a predetermined number and the actual number tickets

2、, comprehensive utilization of the istical tables, the number combination, multiple linear ysis were used to construct the voyage, different fare classes on pricing and price stability , using Thisraimsyze the mechanism of theeffect of thedifferent space different voyage of the price and a predeterm

3、ined number and the actual number tickets, comprehensive utilization of the istical tables, the number combination, multiple linear ysis were used to construct the voyage, different fare classes on pricing and price stability , using Excel Eviews software, degree of influence of different space of p

4、redetermined number of price is obtained. And from the aspects of the number voyages, compared to the original price, reflects the accuracy of the . the results are combined with the actual number and the actual price, the stability ofthecruiseticket priceisstudied,and theimpact mechanism ofthe nomi

5、nal price and the reservation number of the cruise liner is revealed.Number of problems for Schedule 1 of several thin given data forecast data ysis of every voyage of the e space is booked, through ysis, obtains relevant data, and predicting the reservation number on the er of influence, the chart

6、can be uitive to see the influence of factors on the pricing, in order to e the assessment of roduce concept of difference, the data yzed by using three methods and draws , and predicting of the voyage of the actual number of reservations non y accumulative table.The second e according to the proble

7、m of a given data, respectively on voyage and the number of voyage and pricing of theks were istics ysis, and compared ks and the voyage of the actual bookings of the number. Prediction of every voyage each booking price list sheet3.k booking price, perfect every Problems combined with the results o

8、f two questions are given, in order k including a predetermined andExcelfordataofto reveal the relationship n n withdifferentnumberofreservations,ysis, kly reservation range and k will the number reservations related to the relationship bet by the company booking average price.n the number of kly Qu

9、estion four according to the annex has been a sound of the table, establishmentofum of each cruise ship ticket revenue , and theexpectedticketreturnflight upgrades( up to-class and second-class cabin is not full, tourists after boarding, t is, the original book second class tourists through appropri

10、ate class, third class tourists so be through the appropriate increase up class, second class). The establishment of tourist willingness makingareasonableplantthe umreturnhe price factors, the price Finally the were ysis, to the influence mechanism m as a whole, cut is unique.of the predetermined nu

11、mber is improved, clear idea ysis a comprehensive, feature distinct.1题的重一背景知 3.预订：事先订相关数二2题的分一、对问题的总二、对具体问题的分1问题一的分析：针对附表 1 Excel2. 1题的重一背景知 3.预订：事先订相关数二2题的分一、对问题的总二、对具体问题的分1问题一的分析：针对附表 1 Excel2. 问题二的分析：根据问题一给出的数据，分别对航次和周数进行统计航行各周预订舱位的价格，完善每次航行预订舱位价格表 sheet3。3. 问题三的分析：结合前两个问题给出的结果，为了揭示不同预订人数下Excel8。

12、1.升舱：将机票3型的假3. 价格稳定：价格稳定是指价格总水平的稳定，它是一个宏观经济概念。一二、符号说,3型的假3. 价格稳定：价格稳定是指价格总水平的稳定，它是一个宏观经济概念。一二、符号说,0kkk )TtT 123456789ek T在邮轮启航之前第周内，第次启航，舱位的实际预订量。在邮轮启航之前第 周内，对第 次启航，舱位 预订的在观测点第 周，第 次启航，舱位 的累积总需求。第次航行，舱位启航时的实际总需求，即第0周时的累积需求。第 次航行，舱位 启航时的最终总需求1.预期收益率：预期收益率也称为期望收益率是指如果没有意外事件发5型的建立与求一、问题一的分析与1. 本问题根据附表

13、1 数据，通过 Excel 2. 2.1：邮轮启航之前 周内，Xk(it2.2，；X(i)X5型的建立与求一、问题一的分析与1. 本问题根据附表 1 数据，通过 Excel 2. 2.1：邮轮启航之前 周内，Xk(it2.2，；X(i)X(i1)Ik iIi1Fkt tCitti 45103,315,3158 82,219,305，等等；数据表中的“?”是还没有发生有待航次10123456789等等等等等等等等等等等等等等等等等等等等等等等等等等等等等 等舱周人人人人人人人人人人人人人人人人人人人人人人人人人人人人人 人数275712462578227974753590102686298936

14、539121124105631042495991261262244832333938368126542027611 2 8 7921XX(i)C C 45103,315,3158 82,219,305，等等；数据表中的“?”是还没有发生有待航次10123456789等等等等等等等等等等等等等等等等等等等等等等等等等等等等等 等舱周人人人人人人人人人人人人人人人人人人人人人人人人人人人人人 人数275712462578227974753590102686298936539121124105631042495991261262244832333938368126542027611 2 8 7921

15、XX(i)C C22002455305596372549222443452325032583858888361062533531022972971112873001033397282364102326326106269325109275403995？3463463103764485？633674281934204203？038245720437389467237？8040210446469200410500141？440212448491095？4 2200245530559637254922244345232503258385888836106253353102297297111287300

16、1033397282364102326326106269325109275403995？3463463103764485？633674281934204203？038245720437389467237？8040210446469200410500141？440212448491095？4 0492-475=17、213-210=3、442-441=1、495-441=54、212-210=2、448-446=25200+9.25=209.25、410+9.25=419.25、500+9.25=509.251 所有第 6 190+21.75=211.75 389+21.75=410.75 （1

17、）直观志变量及其格式和包含的周期等。（1）直观志变量及其格式和包含的周期等。6-10 航次的数据做分析【】框左侧的候选变量列表框中选择【VAR000001】选项其移入【变量】列表框中，选择【Year，not periodic】将其移入【时间轴列 表 框 ， 单 击 【 确 定 】 按 钮 即 可 生 成 线 图 。域，然后将【VAR000001】拖X【】框。将【VAR000001】移ACF VARIABLES=VAR00001/MXAUTO 2.4（一）62.4（一）6二、问题二的分析与1. 价格，完善每次航行预订舱位价格表 sheet3。2. 到4 3 2 x = 8 7 6 二、问题二的分

18、析与1. 价格，完善每次航行预订舱位价格表 sheet3。2. 到4 3 2 x = 8 7 6 y=153015701690176018801900197019901960197018801810 p 1.0e+003 -Y=-当 x=0 时 y=1630三、问题三的分析与1. 2. 售票收益模型，并计算第 8 次航行的预期售票收益售票收益模型，并计算第 8 次航行的预期售票收益 五、问题五的分析与1. 对问题的分析：假设头等、二等舱位未满的情况下，游客登船后，可进适当的加价升到头等舱、二等舱2. 。为在观测点第 周，第 次启航，舱位 的累积总需求，当头等舱有450 450 450 450 450 450 450 450 450 338 344 450 451 413 397 460 382 3