Assignment: Statistical Labs Portfolio
The local manager of a restaurant chain hired you to perform a statistical analysis on number of customers in each day and different time periods. Your analysis will help them to decide how to allocate their resources. You started your job by recording the number of customers in each day in different time periods. Each cell represents the average number of customers for 5 weeks of study. The data of your observations is recorded in the "restaurant" excel file. This file is in D2L. After reviewing your data, the manager assigned you some tasks. In another word, each lab assignment is a request made by the manager and you should follow the manager exactly and provide a report to get paid after reviewing your report. You should follow the following guidelines:
Portfolio Guidelines
• The Excel Portfolio will consist of all the Microsoft Excel lab assignments.
• It should be in the same sequence as that of being instructed, from lab assignment 1 to 10.
• The portfolio will consist of a cover page for the entire portfolio. The entire portfolio needs a table of contents after the cover page.
• The written text will be double-spaced, font size 12, and Times New roman or Arial font. Set the Top, Bottom, Left, and right Margins to 1 inch.
• Appropriately name each figure and table and refer to them by their names in the explanatory paragraphs.
• Use the same format for all figures for the entire portfolio.
• Use the same format for all tables for the entire portfolio.
• Each assignment should start in a new window. First the text will appear and then related figures and tables.
• Final Portfolio should be submitted online in a single document consisting of all assignments.
• Failure to comply with these instructions will result in a partial or a zero grade for the Portfolio.
Computer Lab Assignment 1
1. Using Excel and the "restaurant" data set file located in D2L, conduct a "Descriptive Statistics" for the class 1 for days 1 to 7.
2. Write an explanatory paragraph (not to exceed one page; double-spaced) addressing the results of your Descriptive Statistics.
3. Explain about the measures of location (mean, median, and mode), specifically state if the distribution of numbers is positively or negatively skewed, and how did you determine it. Explain about the measures of dispersion (variance, standard deviation, and standard error).
4. The Computer Lab Assignment results must follow the following sequence:
Page 1: Title of the Lab Assignment at the top of page, Explanatory paragraphs after the title. Page 2: Data for class 1 (days 1 to 7) in a table and Descriptive Statistics Table.
Computer Lab Assignment 2
1. Using Excel and the "restaurant" data set file located in D2L, conduct a "Descriptive Statistics" for the class 9 for days 1 to 7.
2. Write an explanatory paragraph (not to exceed one page; double-spaced) addressing the results of your Descriptive Statistics.
3. Explain about the measures of location (mean, median, and mode), specifically state if the distribution of numbers is positively or negatively skewed, and how did you determine it. Explain about the measures of dispersion (variance, standard deviation, and standard error).
4. The Computer Lab Assignment results must follow the following sequence:
Page 1: Title of the Lab Assignment at the top of page, Explanatory paragraphs after the title. Page 2: Data for class 9 (days 1 to 7) in a table and Descriptive Statistics Table.
Computer Lab Assignment 3
1. Use Excel and the "restaurant" data set file located in D2L for this assignment.
2. Define variable X as the number of customers in Day 1 for the periods 10:00 am to 12:00 pm, 12:00 pm to 2:00 pm, 2:00 pm to 4:00 pm, 4:00 pm to 6:00 pm, 6:00 pm to 8:00 pm to 10:00 pm, and 10:00 pm to 12:00 am. Show this new variable in a separate table. Construct a Histogram, frequency polygon, and cumulative frequency polygon for this variable.
3. Define variable Y as the number of customers in Day 2 for the periods 10:00 am to 12:00 pm, 12:00 pm to 2:00 pm, 2:00 pm to 4:00 pm, 4:00 pm to 6:00 pm, 6:00 pm to 8:00 pm to 10:00 pm, and 10:00 pm to 12:00 am. Show this new variable in a separate table. Construct a Histogram, frequency polygon, and cumulative frequency polygon for this variable.
4. Write an explanatory one paragraph, not to exceed one page; double-spaced, addressing the results of your frequency distribution table, histogram, polygons for variable X.
5. Write an explanatory one paragraph, not to exceed one page; double-spaced, addressing the results of your frequency distribution table, histogram, polygons for variable Y.
6. The Computer Lab Assignment must follow the following sequence:
Page 1: Title of the Lab Assignment at the top of page, Explanatory paragraphs after the title. First paragraph is about part 2 and second paragraph is about part 3.
Pages 2-5: Variables X and Y. Histogram, frequency polygon, and cumulative frequency polygon for variable X and histogram, frequency polygon, and cumulative frequency polygon for variable Y.
Computer Lab Assignment 4
1. Use Excel and the "restaurant" data set file located in D2L for this assignment.
2. Define variable X as the number of customers in Day 2 for all classes (class 1 to 14). Show this new variable in a separate table.
3. Define variable Y as the number of customers in Day 3 for all classes (class 1 to 14). Show this new variable in a separate table.
4. Define variable Z as the number of customers in Day 4 for all classes (class 1 to 14). Show this new variable in a separate table.
5. Draw scatter plot for each of variables X, Y, and Z in relation to the classes.
6. Discuss if the data for either X, Y, or Z show any trend. Discuss for each variable in a separate paragraph.
7. The Computer Lab Assignment must follow the following sequence:
Page 1: Title of the Lab Assignment at the top of page, Explanatory paragraphs after the title. Add related three paragraphs for part 6 (Discussion on scatter plots results of X, Y, and Z).
Pages 2-5: Tables of parts 2, 3, and 4. Scatter plots of part 5.
Computer Lab Assignment 5
1. Use Excel and the "restaurant" data set file located in D2L for this assignment.
2. Define variable X as the number of customers in class 1 for all days. Show this new variable in a separate table. Construct a Histogram, frequency polygon, and cumulative frequency polygon for this variable.
3. Define variable Y as the number of customers in class 2 for all days. Show this new variable in a separate table. Construct a Histogram, frequency polygon, and cumulative frequency polygon for this variable.
4. Write an explanatory one paragraph, not to exceed one page; double-spaced, addressing the results of your frequency distribution table, histogram, polygons for variable X.
5. Write an explanatory one paragraph, not to exceed one page; double-spaced, addressing the results of your frequency distribution table, histogram, polygons for variable Y.
6. The Computer Lab Assignment must follow the following sequence:
Page 1: Title of the Lab Assignment at the top of page, Explanatory paragraphs after the title. First paragraph is about part 2 and second paragraph is about part 3.
Pages 2-5: Variables X and Y. Histogram, frequency polygon, and cumulative frequency polygon for variable X and histogram, frequency polygon, and cumulative frequency polygon for variable Y.
Computer Lab Assignment 6
1. Use Excel and the "restaurant" data set file located in D2L for this assignment.
2. Define variable X as the number of customers in class 9 for all days. Show this new variable in a separate table.
3. Define variable Y as the number of customers in class 10 for all days. Show this new variable in a separate table.
4. Define variable Z as the number of customers in class 11 for all days. Show this new variable in a separate table.
5. Draw scatter plot for each of variables X, Y, and Z.
6. Discuss if the data for either X, Y, or Z show any trend. Discuss for each variable in a separate paragraph.
7. The Computer Lab Assignment must follow the following sequence:
Page 1: Title of the Lab Assignment at the top of page, Explanatory paragraphs after the title. Add related three paragraphs for part 6 (Discussion on scatter plots results of X, Y, and Z).
Pages 2-5: Tables of parts 2, 3, and 4 and scatter plots of part 5.
Computer Lab Assignment 7
1. Use Excel and the "restaurant" data set file located in D2L for this assignment.
2. Consider the class 5 of data for all days. Assume ?? is the probable number of customers in this period (2:00 pm - 3:00 pm). Also assume the number of customers in the period follows a Poisson distribution. Find ?? such that the probability of having less that ?? customer in that period is 80%. (Assume ?? is the average of class 5.)
3. If for every 4 customers we need 1 waiter/waitress, how many waitresses do we need operational at that period? Does the restaurant need to hire new waiters/waitresses, or does it need to fire? How many hires/fires?
4. repeat the same process (Parts 2 and 3) for class 6 and find the appropriate ??.
5. The Computer Lab Assignment must follow the following sequence:
Page 1-2: Title of the Lab Assignment at the top of page, Explanatory paragraphs after the title. Add related two paragraphs for parts 2, 3, 4.
Pages 3: Tables of part 2, 4.
Computer Lab Assignment 8
1. Use Excel and the "restaurant" data set file located in D2L for this assignment.
2. Consider the class 7 of data for all days. Assume ?? is the probable number of customers in this period (2:00 pm - 3:00 pm). Also assume the number of customers in the period follows a Normal distribution. Find ?? such that the probability of having less that ?? customer in that period is 80%. Assume ?? and ?? are the average and standard deviation of this class.
3. If for every 4 customers we need 1 waiter/waitress, how many waitresses do we need operational at that period? Does the restaurant need to hire new waiters/waitresses, or does it need to fire? How many hires/fires?
4. repeat the same process (Parts 2 and 3) for class 8 and find the appropriate ??.
5. The Computer Lab Assignment must follow the following sequence:
Page 1-2: Title of the Lab Assignment at the top of page, Explanatory paragraphs after the title. Add related paragraphs for parts 2, 3, 4.
Pages 3: Tables of parts 2, 4.
Computer Lab Assignment 9
1. Use Excel and the "restaurant" data set file located in D2L for this assignment.
2. For each class (Class 1 to 14), consider the number of customers for day 7. Call this new variable; day 7 data, as X1. Consider the number of waiters/waitresses as variable X2. Consider the customer satisfaction as variable Y. In another word, create a table for variables Y, X1, X2:
Dependent Variable: Y
Independent Variables: X1, X2
3. Find a linear regression model that shows the relation between Y as dependent variable and X1, X2 as independent variables. In another word, find values of b0, b1, b2 in the following equation, using excel:
Y^ = b0 + b1X1 + b2X2
4. Comment on the followings by writing an explanatory paragraph from the results of your regression model:
• r-Square
• r (coefficient of correlation)
• Adjusted r-Square
• α-values of the regression model and acceptance of variables X1, X2
• f-value of the regression model
5. The Computer Lab Assignment must follow the following sequence:
Page 1: Title of the Lab Assignment at the top of page, Explanatory paragraphs after the title. Add related paragraphs for parts 1, 2, 3, 4.
Page 2, 3: Table for variables Y, X1, X2 and Excel regression tables.
Computer Lab Assignment 10
1. Use Excel and the "restaurant" data set file located in D2L for this assignment.
2. For each class (Class 1 to 14), sum the number of customers for all days. Call this new variable X1. Consider the number of waiters/waitresses as variable X2. Consider the customer satisfaction as variable
Y. In another word, create a table for variables Y, X1, X2:
Dependent Variable: Y
Independent Variables: X1, X2
3. Find a linear regression model that shows the relation between Y as dependent variable and X1, X2 as independent variables. In another word, find values of b0, b1, b2 in the following equation, using excel:
Y^ = b0 + b1X1 + b2X2
4. Comment on the followings by writing an explanatory paragraph from the results of your regression model:
• r-Square
• r (coefficient of correlation)
• Adjusted r-Square
• α-values of the regression model and acceptance of variables X1, X2
• f-value of the regression model
5. The Computer Lab Assignment must follow the following sequence:
Page 1: Title of the Lab Assignment at the top of page, Explanatory paragraphs after the title. Add related paragraphs for parts 1, 2, 3, 4.
Page 2, 3: Table for variables Y, X1, X2 and Excel regression tables.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Restaurant.rar