piecewise linear model: forecasting box-office revenue of new movies

Project Description:

please see attached excel file and below for questions (a) through (e). when providing excel file, please save as a .xls file as i only have older version of excel. please answer all questions in order. i just want to double check my answers. thanks.

using the movie data set posted (moviedata6.xlsx), build a piecewise linear model based on screens:

(a) split the data into two segments by 1st week screens at 2500.
(b) what is the new model for screens ≤2500, _ 2500?
(c) what is the significance of the models? what variables are significant for each model? interpret the meaning of model coefficients on box office
(d) plot predicted vs. actual box-office revenue
(e) make forecast again for avatar based on your model
Skills Required:
Project Stats:

Price Type: Negotiable

Refunded
Total Proposals: 9
1 Current viewersl
13 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.0
    1 Jobs 1 Reviews
    $0 in 0 Day
  • 4.8
    60 Jobs 32 Reviews
    $0 in 0 Day
  • 4.8
    405 Jobs 247 Reviews
    $0 in 0 Day
  • 4.9
    95 Jobs 45 Reviews
    $0 in 0 Day
  • 4.3
    309 Jobs 189 Reviews
    $20 in 0 Day
  • 4.1
    70 Jobs 30 Reviews
    $15 in 0 Day