1. pivot table (1) basic data Please paste the table header and 1-2 rows of the data, and explain the meaning of the data. (2) pivot table Please paste the pivot table here. (3) function of this pivot table Please explain the pivot table that you have created, what is the function of the result.

4. What is the difference between trend and seasonality in time series data? 5. Here are the errors associated with a particular forecast over the past 5 months, in chronological order: 5, 10, -15, 0, 8. In which month was the forecast perfectly accurate? In which month was the forecast the least accurate? In which month or months was the forecast too high? (Noteshaper Ramp Up # 23) 6. Tutoring Center needs to allocate tutors this week for office appointments, so it needs to forecast the number of students who will seek appointments. The director has gathered the following time series data recently: Time Period Code Student Appointments Jan 6 - 10 95 Jan 13 - 17 80 Jan 20 - 24 65 Jan 27 – 31 4 50 a) What is the naïve forecast for the number of student appointments for Time Period 5 (Feb 3– 7)? b) What is the 2 week moving average for Time Period 5? c) What is the 3 week moving average for Time Period 5? d) What is the forecast for Time Period 5 using exponential smoothing with alpha =…

    41.The ______ are (is) used to determine the amount of money that an organization would save if it used a particular test in place of the test it currently uses to select employees. a.  Brogden-Cronbach-Gleser formula b.  Taylor-Russell Tables c.expectancy charts d.  Lawshe tables   42.When the criterion validity coefficient is ____, and the selection ratio is ____, a test will have the most utility in selecting successful employees. a.  large / large b.  large / small c.small / small  d.  small / large   43.A test is considered to have _____ if there are race differences in test scores that are unrelated to the construct being measured. a.  differential validity       b.  measurement bias c.selection bias        d.  adverse impact   44.If the selection rate for any of the protected groups is less than 80% of the…

Kay and Micheal Passe publish what's Happening?--a biweekly newspaper to publicize local events. whats happening? has a few subscribers; it typically is sold at checkout stands. Much of the revenue comes from advertisers of garage sales and supermarket specials. In an effort to reduce costs associated with printing too many papers or delivering them to the wrong location, Micheal implemented a computerized system to collect sales data. Sales-counter scanners accurately record sales data for each location. Since the system was implemented, total sales volume has steadily declined. selling advertising space and maintainting shelf space at supermarkets are getting deifficult. Reduced revenue makes controlling costs all the more important. For each issue. Micheal caefully makes a forecast based on sales data collected at each location. Then he orders papers to be printed and distributed in quantities matching the forecast. Micheal's forecast refect a downward trend, which is present in the…