Tutor profile: Leah G.
Subject: Microsoft Excel
I have 1 column of data that I would like to change to be rows. What is the quickest way to rearrange my data?
This answer applies to Excel 2007/2010. 1. Highlight the column of data that you would like to rearrange into rows. 2. Copy this data (Ctrl +C, "Copy" on the left-hand side of the Home tab, or right-click and select "copy"). 3. Right-click the first cell where you want to paste your data and select the Transpose icon (usually the 4th icon over under "Paste Options"). If you hoover over the icon with your curser, the name of that icon will appear. 4. Be sure to save your changes.
What is a z test and when is it to be used?
The individual z test (symbol z) is used when comparing a single score to the population. The z-score (the value) represents how many standard deviations your score is from the mean. The formula to determine the z score is: z = X – μ / σ. Here is an example of a problem that would require the use of a z test: As a teacher of a fifth grade class, you know that the average fifth grader scores a 120 on the end of the year standardized exam with a standard deviation of 10. You have a student who scores a 150 and another who scores 65. How do these two students compare to the average fifth grader?
An accountant for a large manufacturing company wants to apply for 12 weeks of FMLA leave to take care of her daughter with cancer. Her supervisor denies the request because not having their accountant for 12 weeks creates a a difficult situation for the company. The accountant has worked for this company for 10 years. Is this supervisor in compliance with the law?
No, the supervisor has violated the FMLA. The Family and Medical Leave Act (FMLA) was put into law in 1993. This act enables eligible employees to take up to 12 weeks unpaid leave for certain qualifying events. FMLA applies to employers with more than 50 employees (with a few exceptions). A qualifying event may include one of the following events: 1. the birth of a child and to bond with the newborn child within one year of birth. 2. the placement with the employee of a child for adoption or foster care and to bond with the newly placed child within one year of placement. 3. A serious health condition that makes the employee unable to perform the functions of his or her job, 4. To care for the employee's spouse, son, daughter, or parent who has a serious health condition. In order to be eligible for FMLA, employees must have been with the employer for at least 12 months and worked at least 1250 hours. Employers may require a certification from a health care provider for leave related to a serious health condition. Managers should very careful to prevent eligible employees from taking their FMLA leave. After FMLA leave is over, employers must return the employee to the same or equivalent position with equal pay and benefits. Employers cannot retaliate against an employee for taking FMLA.
needs and Leah will reply soon.