Please evaluate the correlation matrix below, assuming stock price is the response variable in a series of multiple regression equations you plan to run. If you are using this as a diagnostic tool, what are you looking for? If this was your data, how would you proceed?

Consider the levels of GHB for control patients and patients under treatment:

control:

0.7, 0.5, 0.6, 0.8, 0.8, 1.1, 0.5, 0.4, 0.6, 0.7, 0.5, 1.0, 1.5, 1.4, 0.7, 0.9, 0.6, 0.8, 0.9, 1.0, 0.7, 0.7, 0.7, 0.8, 1.0, 0.6, 1.2, 0.7, 0.9, 0.9

treatment:

0.7, 0.8, 0.7, 0.6, 1.0, 0.9, 1.4, 1.4, 1.0, 0.8, 0.6, 1.3, 0.4, 0.5, 0.9, 1.0, 1.0, 0.5, 0.7, 1.0, 1.2, 1.3, 0.6, 1.0, 0.8, 1.4, 0.8, 1.0, 1.3, 1.4

a. Do a 95% hypothesis test to test if:

(H0) the mean CONTROL level is greater than 0.89 vs. (Ha) he mean CONTROL level is less than 0.89.

Report the p-value:

Reject Null hypothesis at the 95% level of confidence?

yes OR no    

b. Do a 95% hypothesis test to test if:

(H0) the mean of the CONTROL is equal to the mean of the TREATMENT vs. (Ha) the mean of the CONTROL is not equal to the mean of the TREATMENT.

Report the p-value:

Reject Null hypothesis at the 95% level of confidence?

yes OR no    

c. Do a 95% hypothesis test to test if:

(H0) the mean of the CONTROL is less than the mean of the TREATMENT vs. (Ha) the mean of the CONTROL is greater than the mean of the TREATMENT (Ha).

Report the p-value: .

Reject Null hypothesis at the 95% level of confidence?

yes OR no    

Consider the levels of GHB for control patients and patients under treatment:

control:
0.7, 0.5, 0.6, 0.8, 0.8, 1.1, 0.5, 0.4, 0.6, 0.7, 0.5, 1.0, 1.5, 1.4, 0.7, 0.9, 0.6, 0.8, 0.9, 1.0, 0.7, 0.7, 0.7, 0.8, 1.0, 0.6, 1.2, 0.7, 0.9, 0.9

treatment:
0.7, 0.8, 0.7, 0.6, 1.0, 0.9, 1.4, 1.4, 1.0, 0.8, 0.6, 1.3, 0.4, 0.5, 0.9, 1.0, 1.0, 0.5, 0.7, 1.0, 1.2, 1.3, 0.6, 1.0, 0.8, 1.4, 0.8, 1.0, 1.3, 1.4

a. Do a 95% hypothesis test to test if:

(H0) the mean CONTROL level is greater than 0.89 vs. (Ha) he mean CONTROL level is less than 0.89.

Report the p-value: ___
Reject Null hypothesis at the 95% level of confidence?

no

yes    


b. Do a 95% hypothesis test to test if:

(H0) the mean of the CONTROL is equal to the mean of the TREATMENT vs. (Ha) the mean of the CONTROL is not equal to the mean of the TREATMENT.

Report the p-value: ___
Reject Null hypothesis at the 95% level of confidence?

yes

no    


c. Do a 95% hypothesis test to test if:

(H0) the mean of the CONTROL is less than the mean of the TREATMENT vs. (Ha) the mean of the CONTROL is greater than the mean of the TREATMENT (Ha).

Report the p-value: ___
Reject Null hypothesis at the 95% level of confidence?

yes

no    

An accountant for a large department store has the business objective of developing a model to predict the amount of time it takes to process invoices. Data are collected from the past 32 working days, and the number of invoices processed and completion time (in hours) are shown below. (Hint: First determine which are the independent and dependent variables.) Use Excel:

• Assuming a linear relationship, create a regression model to compute the regression coefficients b₀ and b₁.
• Interpret the meaning of the Y intercept, b₀, and the slope, b₁. What does the slope tell you about the relationship between number of invoices processed and completion time?
• Use the prediction line developed to predict the mean amount of time it would take to process 150 invoices. Would you use the regression model to predict the amount of time it would take to process 350 invoices? Why?
• What is the coefficient of determination, r² ? Interpret its meaning.
• Plot the residuals against the number of invoices processed and also against time. Based on these plots, does the model seem appropriate?

The following are quality control data for a manufacturing process at Kensport Chemical Company. The data show the temperature in degrees centigrade at five points in time during a manufacturing cycle.

The company is interested in using control charts to monitor the temperature of its manufacturing process. Compute the upper and lower control limits for the R chart. (Round your answers to three decimal places.)

UCL=___

LCL=___

Construct the R chart.

12

3 4

Compute the upper and lower control limits for the x chart. (Round your answers to three decimal places.)

UCL=___

LCL=___

Construct the x chart.

12

3 4

What conclusions can be made about the quality of the process?

The R chart indicates that the process variability is  in control/out of control .  - No samples fall/One sample falls/Two samples fall/More than two samples fall...outside the R chart control limits. The x chart indicates that the process mean is  in control/out of control .  No samples fall/One sample falls/Two samples fall/More than two samples fall....outside the x chart control limits.

Beate Klingenberg manages a​ Poughkeepsie, New​ York, movie theater complex called Cinema 8. Each of the eight auditoriums plays a different​ film; the schedule staggers starting times to avoid the large crowds that would occur if all eight movies started at the same time. The theater has a single ticket booth and a cashier who can maintain an average service rate of

280 patrons per hour. Service times are assumed to follow a negative exponential distribution. Arrivals on a normally active day are Poisson distributed and average 200

per hour.

a) Find the average number of moviegoers waiting in line to purchase a ticket.
b) What percentage of the time is the cashier busy?
c) What is the average time that a customer spends in the system?
d) What is the average time spent waiting in line to get to the ticket window?
e) What is the probability that there are more than two people in the system? More than three people? More than four?

/*explain */ Select *

From Student join enrollment on student.ID = enrollment.Student_ID

            join section on section.ID = enrollment.section_ID

            join department on major = department.name

            join faculty on faculty.id = section.faculty_ID

            join address on address.id = student.address_ID

            join Course on section.course_Number = course.course_number and section.dept_id = course.dept_ID

Where

--we want to make sure we have name information for students if we want to reach out to them

Student.Name_Last Not Like ('')

-- the theater department has asked to be out of this study

and Student.Major <> 'Theater'

--no students who have failed as we're looking for passing grades

and Grade > '1.33'

--we want to make sure we only have instructors, and the theater department is not part of this study

and Faculty.job in

            (Select job

            From Faculty

            Where Job not in ('Administrative','General Services','Human Resources')

            and Dept <> 'THT')

and Section_ID >=1

--summer courses don't always reflect accurately given their tight schedule and rapid fire delivery of materials

and Semester <> 'Summer'

--we don't want bias of an adivosr giving better grades

and Student.Advisor_ID <> Section.Faculty_ID

-- we don't want bias if a student is possibly a faculty members child

and Student.Address_ID <> Faculty.Address_ID

Order by Student.Name_Last, Grade desc, Faculty.Name_Last, Major

1. Based on the output from the explain command, determine the steps you would take (building indexes on certain columns, modifying the query, both, etc.) to get the same output, but improve overall performance.
2. Execute three steps that you think would make for improvement in the performance of this query. Report their run time in the table below.

Evaluate the impact of the steps you took, what their potential benefits and setbacks may be, and what you would advise as the next steps to improve the performance of this query.

A solenoid has N=1000 turns, length l=20 cm, and radius r=1.0 cm. (a) What is its self-inductance? (b) You are ramping up the current from 0 to 1.0 A in 1.0 s. How much voltage do you have to apply? (c) Calculate the energy stored in the inductor when the current is 1.0 A.

10. A researcher claims that the mean rate of individuals below poverty in the City of Chicago is below 17 %. Based on the data represented for the years 2005 – 2011, perform a hypothesis test to test his claim using a significance level of α = 0.10.

11. Would your conclusion change for question 10 if you used a significance level of α = 0.05? Explain.

12. A survey conducted at Chicago Public Schools (CPS) involving high school students on whether they had participated in binged drinking during the past month. Binge drinking was defined as 5 or more drinks in a row on one or more of the past 30 days.

a. From the sample data is there evidence that the proportion of students who participate in binge drinking is greater than 10%? Write a null and alternative hypothesis and perform an appropriate significance test using α=0.05.

b. Construct a 90% Confidence Interval for the population proportion. Does it support the same conclusion as in 12a? Explain.

What levels of pay and benefits should you offer?

An important element of the human resource function is the determination and administration of pay and benefits. Pay includes employees' base salaries, pay raises, and bonuses, and is determined by a number of factors such as characteristics of the organization, the nature of the job, and levels of performance. Employee benefits are based on membership in an organization (and not necessarily on the particular job held) and include sick days, vacation days, and medical and life insurance. It is important to link pay to behaviors or results that contribute to organizational effectiveness.

Read the case concerning one of the leading hotel chains in the world, The Four Seasons Hotels and Resorts. The Four Seasons has an excellent reputation for customer service and also for employee satisfaction. Afterwards, analyze the reasons behind this reputation.

In 2015, Four Seasons Hotels and Resorts was one of only 12 companies to be ranked one of the "100 Best Companies to Work For" every year since Fortune magazine started this annual list. The Four Seasons often receives other awards and recognition such as being named the "Best Hotel Group Worldwide" by Gallivanter's Guide and dominating Travel & Leisure's World's Best Awards Readers' Poll and Condé Nast Traveler's Readers' Choice Awards based on customers' responses. In an industry in which annual turnover rates are over 35%, the Four Seasons' is around 13%. Evidently, employees and customers alike are satisfied with how they are treated at the Four Seasons. Understanding that the two are causally linked is perhaps the key to the Four Seasons' success. As the Four Seasons' founder, Isadore Sharp said, "How you treat your employees is how you expect them to treat the customer."

The Four Seasons was founded by Sharp in 1961 when he opened his first hotel. It was called the Four Seasons Motor Hotel, located in a less-than-desirable area outside downtown Toronto. Whereas his first hotel had 125 inexpensively priced rooms appealing to the individual traveler, his fourth hotel was built to appeal to business travelers and conventions. It had 1,600 rooms, conference facilities, several restaurants and banquet halls, and an arcade of shops. Both styles of hotels were successful, but Sharp decided he could provide customers with a different kind of hotel experience by combining the best features of both kinds of hotel experiences—the sense of closeness and personal attention that a small hotel brings with the amenities of a big hotel to suit the needs of business travelers.

Sharp sought to provide the kind of personal service that would really help business travelers on the road—giving them the amenities they have at home and in the office, amenities they miss when traveling on business. The Four Seasons was the first hotel chain to provide bathrobes, shampoo, around-the-clock room service, laundry and dry cleaning services, large desks in every room, two-line phones, and around-the-clock secretarial assistance. While these are relatively concrete ways of personalizing the hotel experience, Sharp realized that how employees treat customers is just as, or perhaps even more, important. When employees view each customer as a unique individual with his or her own needs and desires, and empathetically try to meet these needs and desires and help customers overcome any problems or challenges they face and truly enjoy their hotel experience, a hotel can indeed serve the purpose of a home away from home (and an office away from office), and customers are likely to be loyal and highly-satisfied.

Sharp realized that for employees to treat customers well, the Four Seasons needed to treat its employees well. Salaries are relatively high at the Four Seasons by industry standards. Employees participate in a profit sharing plan, and the company contributes to their 401(k) plans. Four Seasons provides medical and dental insurance. All employees get free meals in the hotel cafeteria, have access to staff showers and a locker room, and receive an additional highly attractive benefit—once a new employee has worked for the Four Seasons for six months, he or she can stay for three nights free at any Four Seasons hotel or resort in the world. After a year of employment, this benefit increases to six free nights, and it continues to grow as tenure with the company increases. Employees like waitress Michelle De Rochemont love this benefit. As she said, "You're never treated like just an employee. You're a guest . . . You come back from those trips on fire. You want to do so much for the guest." The Four Seasons also tends to promote from within. For example, while recent college graduates may start out as assistant managers, those who do well and have high aspirations could potentially become general managers in fewer than 15 years. This promotion system helps to ensure that managers have empathy and respect for those in lower-level positions as well as the ingrained ethos of treating others (employees, subordinates, coworkers, and customers) as they would like to be treated. All in all, treating employees well leads to satisfied customers at the Four Seasons.

1.The Four Seasons Hotel and Resorts can causally link its ____________ to its customers’ satisfaction and the many awards it has received including being one of the “100 Best Companies to Work For.”

A.use of programmed decision making

B.high turnover rate

C.high levels of pay and benefits

D.use of strict supervision over its employees

E.cost cutting measures

2.The Four Seasons uses ________ to motivate superior customer service.

A.high levels of pay and benefits

B.high pay levels with low levels of benefits

C.average pay levels with average benefits

D.average pay levels with high levels of benefits

E.high pay combined with average benefits

3.Which of the following does the Four Seasons have to offer by law?

A.matching contributions to 401(k) plans

B.high salaries

C.profit sharing plans

D.free meals in the cafeteria

E.Social Security insurance

4.Why does the Four Seasons continue to offer such extremely expensive benefits to its employees?

A.The Four Seasons focuses only on long-term costs, and these are short-term costs.

B.The workers’ union negotiated them.

C.The benefits offered by the Four Seasons are actually normal in the luxury hotel market.

D.It can write them off on the corporation’s income taxes.

E. The value gained in worker motivation outweighs the cost of the benefits in the long run.

5.The Four Seasons pays high salaries and provides expensive benefits. This suggests they are not following a(n) ______ strategy.

A.cafeteria plan

B.low-cost

C.employee satisfaction

D.high-performance

E.customer service focused

6.The Four seasons provides some unusual benefits. As described in the case, which of the following is NOT one of the benefits that sets the Four Seasons apart from other hotel chains?

A.high levels of health and dental insurance

B.free vacations at company-owned resorts

C.accrued vacation and sick leave days

D.free meals in the hotel cafeteria

E.access to staff showers and locker rooms

7.The Four Seasons offers _____ to its employees. Employees say this benefit lets them know what the guests feel like and makes them want to do even more for guests.

A.locker rooms and employee showers

B.free stays as guests at any of the company’s properties

C.high pay levels

D.matching 401(k) programs

E.company products such as robes and shampoos