Minitab Individual Reflection Report

Theme of the Coursework

‘Film 2011’ is a large corporation specialising in the entertainment industry.  Recently a proposal has been put forward to expand the business by building its own chain of cinemas UK wide. Prior to implementing such a proposal a research has been carried out to assess the performance of three other cinema chains (that is, chains A, B, and C) which have already been established throughout the UK. Chain A, unlike the other two chains employs cinema passes which are valid for either 4 or 8 weeks (for promotional purposes).

To carry out this assessment the directors of the ‘Film2011’ corporation collected information on a random sample of 128 cinemas throughout the UK (England, Scotland and Wales).  The directors claim that the average total monthly sales of the cinemas is £285,000.

The information is collected from a random sample of 128 cinemas and is stored in the Minitab data file ‘FILM2011.MTW’.  It can be obtained from the MSO4730 Module Page on Unihub.

Cinemas were randomly selected from England, Scotland and Wales.  Each cinema is run by one manager.  Each cinema manager has completed a questionnaire and the collected data information includes the columns (variables) given below.

Reflection

In the following tables it can be seen that there were cross tables, for size and gender of the manager on the columns, whereas the rows comprise of chain, region and location, as the data set is based on the number of cinemas, it, therefore, divides the columns into two subgroups and rows into three, there are three chains, including Chain A, Chain B, and Chain C. Moreover, there are three regions as well, including England, Scotland, and Wales, moreover the locations include locations within town and outside town. This is the distribution of the rows.

Moreover, the distribution of the columns is based on sizes, including the sizes of null, where size is not available, and the rest are segregated into small, medium, and large sizes. It can also be understood that this is a feature of cinema. The second column is based on gender; this column is based on the two values, male and female, there is one missing values column, labeled null here as well.

After that, there is an ANOVA, and it encompasses two variables, the dependent or observed variable would be the total earnings per month, and the independent variable or the factor will be the geographical region. This can give us useful results as it will tell us whether there is a difference in variance in the three states of the UK in the study. After that, there is a box plot of the totals according to the four variables, size, location, region, and chain. This would elaborate the variance and the spread in each subcategory and each variable within that category.

Regression

Regression

It can be seen that the model is highly significant, and in the analysis the predictive power or the adjusted R square is 82.6%, moving on, it can be said that advertisement, chain C, Region within the city, sizes small and medium along with the constant are all significant. This illustrates the need and necessity of multiple linear regression.

Cross Tables

Cross Tables

This table depicts a cross table, and it takes Chain, Location, and region in the rows and Gender along with the size of cinema in the columns, it can be seen that the segment that has most cinemas is a medium cinema with a Male manager, in Scotland, in Chain B in the town, this has a total of 4 cinemas in place.

ANOVA

ANOVA

It can be seen that the ANOVA is significant, and therefore, it can also be illustrated that the overall difference between the three regions of the UK is significant. This highlights that the company should focus on regional highlights to be more profitable.

Box Plot

Boxplot of Total

This is a box plot, and it can be seen that the totals are graphed and the widest spread is of a large cinema, out of town, in England, with chain C. whereas the smallest and most concentrated cinema is of a large cinema out of town, in Wales, of Chain B.

Conclusion

It can be said that the cinemas with male managers are more than that of the female managers, as the ANOVA is significant, it can be deduced that there is a significant difference in the three regions of the UK, and as this difference is highly significant, it is wise for the company to focus on more profitable regions, or region with lesser variance, to reduce the element of risk.

You May Also Like

The deadline is near. Don’t worry. The Best Writer is here for Help.