Application assignment: using Excel

Descriptive Statistics of Quantitative Data (measured on Ratio scale).

Use this file for submission, but use Excel to do your work and copy and paste in the appropriate places identified in this word file.

Note: The following Excel functions in answering Questions 1 and 2 below.

AVERAGE , AVEDEV, COUNT, CORREL, MIN, MAX, MDIAN, MODE, STDEV , STDEVP, STDEV.P, and STDEV.S

Q3. Data Analysis descriptive   Option on Excel 2010 or later to obtain descriptive statistics (Mean, Standard Error, Median, Mode,… ) of both variables X and Y.

Insert your answer here .

Note: Copy the data for the two variables into an excel file and calculate the Descriptive Statistics of both X and Y (using Excel) as explained in class. After you find the required statistics in excel copy them and paste your answer below.

Descriptive for the X values:

Descriptive for the X values:  

Table 1

Kirk is a bright individual who is being groomed for the Controller’s position in a medium-sized manufacturing firm. After his first year as Assistant Controller, the officers of the firm were starting to include him in major company functions. For instance, today he was attending the monthly financial statement summary given at a prestigious consulting firm. During the meeting, Kirk was intrigued at how all the financial data he had been accumulating was transformed by the consultant into revealing charts and graphs. Kirk was generally optimistic about the session and the company’s future until the consultant started talking about the new manufacturing plant the company was adding to the current location and the costs per unit of the chemically plated products it produced. At that time, Bob (the President) and John (the chemical engineer) started talking about waste treatment and disposal problems. John mentioned that the current waste facilities were not adequate to handle the waste products that would be created by the “ultramodern” new plant in a manner that would meet the industry's fairly high standards, although they could still comply with federal standards. Kirk’s boss, Henry, noted that the estimated cost per unit would be increased if the waste treatment facilities were upgraded according to recent industry standards. While industry standards are presently more stringent than federal regulations, environmentalists are strongly pressuring for more stringent regulations at the federal level. Bob mentioned that since their closest competitor did not have the waste treatment facilities that already existed at their firm, he was not in favor of further expenditure in this area. Most managers at this meeting resoundingly agreed with Bob, and business continued on to another topic. Kirk did not hear a word during the rest of the meeting. He kept wondering how the company could possibly have such a casual attitude toward the environment. Yet he did not know if, how, or when he could share his opinion. Soon he started reflecting on whether this was the right firm for him. What should Kirk do? Putting Corporate Responsibility first, but recognizing the politics at play, what is the most ethical thing to do? The most practical? What strategy would you suggest to Kirk if he came to you for advice?

Read the text and in group of two to five students answer the questions

As a new member of the board of directors for a local bank, Mr. Jack Nelson was being introduced to all the employees in the home office (Headquarters of a firm).

When he was introduced to Mrs. Johnson, he was curious about her work and asked her what the machine she was using did. Mrs. Johnson replied that she really did not know what the machine was called or what it did. She explained that she had been working there for two months and she has not received a clear list describing her tasks, duties and responsibilities yet.

At one of the branch offices, the supervisor in charge spoke to Nelson confidentially, telling him that "something was wrong," but she didn't know what. For one thing, she explained, employee turnover was too high, and no sooner had one employee been put on the job than another one resigned.

All branch supervisors hired their own employees without communication with the home office (Headquarters of a firm) or other branches. In case of job vacancy, the supervisor tried to find a suitable employee to replace the worker who had quit.

After touring the 22 branches and finding similar problems in many of them, Nelson wondered what the home office should do or what action he should take. The banking firm generally was regarded as being a well-run institution that had grown from 27 to 191 employees during the past 8 years. The more he thought about the matter, the more puzzled Nelson became.

He couldn't quite put his finger on the problem, and he didn't know whether to report his findings to the president.

Questions

1. Identify and describe two main problems faced by the bank's home office and branches in terms of HRM. Justify your answer from the text.

2. Discuss HRM ineffective practices that led to such problems. Justify your answer from the text .

3. Based on the Human Resources strategic qualities, discuss the way a high turnover rate can affect the efficiency of the bank .

Note : Answers in Word Format and in details and in Own Words

• The speed at which a processor can process instructions can be increased by making its clock speed higher, or by increasing the amount of L1 cache memory on the processor chip.

  Explain the terms clock speed and L1 cache and briefly discuss how increasing each of them increases the speed at which instructions can be processed.

  The maximum word limit for Question 3(a) is 150 words.

• b.You have the choice of buying two processors:

  • Processor 1 has a clock speed of 4.0 GHz with 32 KiB of L1 cache.
  • Processor 2 has a clock speed of 2.0 GHz with 64 KiB of L1 cache.

  In order to decide which to buy, you decide to estimate the time each processor will take to process a program with 10,000 RISC instructions. Each RISC instruction takes one clock pulse to execute once it is in the registers, and has a size of 4 bytes.

  • i.Show that a program consisting of 10,000 RISC instructions will fit into 64 KiB of L1 cache, but will not fit into 32 KiB of L1 cache.
  • ii.It takes 1 nanosecond (1 x 10^-9 s) to move an instruction from L1 cache to the registers and 9 nanoseconds to move an instruction from L2 cache to the L1 cache. Assume that for Processor 2, all of the instructions can be found in L1 cache and for Processor 1, all of the instructions that won’t fit in L1 cache can be found in L2 cache.

    How much time is needed to load all 10,000 instructions into the registers for each processor. Write your answers in seconds, using scientific notation.

  • iii.For each processor, calculate the time it takes to execute 10,000 RISC instructions. Write your answers in seconds, using scientific notation.
  • iv.Using your results from part (ii) and part (iii), for each processor, calculate the total amount of time to load 10,000 RISC instructors from cache memory to the registers, and then to execute them.

    You may assume that no data is needed for this test program. in each case you will only need to calculate the time to move 10,000 instructions into the registers and the time to execute the 10,000 instructions. You will then find the total time for each processor by adding these two values.

    Write your answers in seconds, using scientific notation.

1. Errors with Pronouns - Faulty Agreement

Pronouns are words that take the place of nouns, noun phrases, or other pronouns. Pronouns can be the subject of a sentence, the object of a sentence, or in the possessive case. A pronoun should agree in number and gender with its antecedent. An antecedent is the word the pronoun stands for. The following is one rule for pronouns.

Rule: Use the singular pronoun with "everyone," "anyone," and "each."

Incorrect: Each player on the girls’ soccer team wants their coach to play them in the championship game.

Correct: Each player on the girls’ soccer team wants her coach to play her in the championship game.

Directions: Click on the blank lines that follow and select the pronoun that agrees with its antecedent.

Swamp Coffee

The Greatest Toronto-Based Band in History

Fan Trivia

1. The band members refuse to reveal how the band got its/their name. Each of the popular theories has its/their merits, but the general public may never know the truth.

2. A local music critic claimed she/her will never forget the first time hearing this band's music. The sound is unique, making it hard to classify. When asked why there are no vocals, lead guitarist Halil Shafak says the message is in the music itself/themselves. .

3. Halil writes most of the songs alone in the studio.He/Him and bass guitarist Seth Spence then rework the songs together.

4. Near the end of the autumn 2013 concert tour, drummer Maya Creedy temporarily quit the band when Halil yelled at her/she for improvising too much. Halil later apologized to Maya and she/her rejoined the band. At the time, she told reporters that she felt bad for Halil because no one is more misunderstood than he/him .

5. Fans designed the band's last three album covers. Each of the winning designers received free concert tickets and had her/our picture taken with the band.

6. When asked if he would ever break up the band and go solo, Halil said the other members of the band were like family, so he/him could never do that to them/they.

Marketing Plan

From the real international market, select a company of your choice wishing to start its activities in Saudi Arabia. The Company hired you as Marketing Manager of Saudi Arabian Region.

You have to establish a marketing department starting from the Analysis of the market, formulate overall marketing goals, objectives, strategies, and tactics within the context of an organization's business, mission, and goals designing and planning the entire function.

Write a Marketing Plan considering the following points (2x5=10 Marks)

1. Introduction, Goals and Objectives

To introduce this section you should include the "mission statement" of the business; an idea of what its goals are for customers, clients, employees and the consumer.

1. Introduction about the business.
2. Business vision and mission
3. Business objective.
4. Products and services offered

2. Environmental Analysis

Conduct an environmental analysis that looks at and comments on your local area and your network of business contacts, competitors and customers.

3. Target Market Analysis

Identify the target market, describing how the company will meet the needs of the consumer better than the competition does.

4. SWOT Analysis

Conduct a SWOT analysis for your chosen company based on your research.

Strengths: List the strengths of the business approach;

Weaknesses: Describe the areas of weakness in the company's operations;

Opportunities: Examine factors that may improve the business's chances of success;

Threats: List the external threats to the business' success.

5. Marketing Mix (4 P’s ) Analysis

Describe each of the 4Ps of your chosen company.

Product or Service

Identify the product or service by what it is, who will buy it, how much they will pay for it and how much it will cost for the company to produce it, why a consumer demand exists for your product, and where the product sits in comparison to similar products/services now available.

Place

Identify the location of the business, why it is located there (strategic, competitive, economic objectives), the expected methods of distribution, and timing objectives.

Promotion

Describe the type of promotional methods that will be used. Identify techniques such as word of mouth, personal selling, direct marketing, sales promotion etc. television, radio, social media and newspaper ads.

Price

The prices of the products or services that reflects the overall company strategy. Should be competitive as well as a reflection of the quality, costs and profit margin.

Assignment No.: 3

Marketing Plan

From the real international market, select a company of your choice wishing to start its activities in Saudi Arabia. The Company hired you as Marketing Manager of Saudi Arabian Region.

You have to establish a marketing department starting from the Analysis of the market, formulate overall marketing goals, objectives, strategies, and tactics within the context of an organization's business, mission, and goals designing and planning the entire function.

Write a Marketing Plan considering the following points (2x5=10 Marks)

1. Introduction, Goals and Objectives

To introduce this section you should include the "mission statement" of the business; an idea of what its goals are for customers, clients, employees and the consumer.

1. Introduction about the business.
2. Business vision and mission
3. Business objective.
4. Products and services offered

2. Environmental Analysis

Conduct an environmental analysis that looks at and comments on your local area and your network of business contacts, competitors and customers.

3. Target Market Analysis

Identify the target market, describing how the company will meet the needs of the consumer better than the competition does.

4. SWOT Analysis

Conduct a SWOT analysis for your chosen company based on your research.

Strengths: List the strengths of the business approach;

Weaknesses: Describe the areas of weakness in the company's operations;

Opportunities: Examine factors that may improve the business's chances of success;

Threats: List the external threats to the business' success.

5. Marketing Mix (4 P’s ) Analysis

Describe each of the 4Ps of your chosen company.

Product or Service

Identify the product or service by what it is, who will buy it, how much they will pay for it and how much it will cost for the company to produce it, why a consumer demand exists for your product, and where the product sits in comparison to similar products/services now available.

Place

Identify the location of the business, why it is located there (strategic, competitive, economic objectives), the expected methods of distribution, and timing objectives.

Promotion

Describe the type of promotional methods that will be used. Identify techniques such as word of mouth, personal selling, direct marketing, sales promotion etc. television, radio, social media and newspaper ads.

Price

The prices of the products or services that reflects the overall company strategy. Should be competitive as well as a reflection of the quality, costs and profit margin.

Write a C program that repeatedly prompts the user for input at a simple prompt (see the sample output below for details). Your program should parse the input and provide output that describes the input specified. To best explain, here's some sample output:

ibrahim@ibrahim-latech:~$ ./prog1

$ ls -a -l -h

Line read: ls -a -l -h

Token(s):

ls

-a

-l

-h

4 token(s) read

$ ls -alh

Line read: ls -alh

Token(s):

ls

-a

-l

-h

2 token(s) read

$ clear

Line read: clear

Token(s):

clear

1 token(s) read

$ exit ibrahim@ibrahim-latech:~$

Note that the first and last lines are not part of program output (i.e., they are of the terminal session launching the program and after its exit). The program prompts the user (with a simple prompt containing just a $ followed by a space) and accepts user input until the command exit is provided, at which point it exits the program and returns to the terminal. For all other user input, it first outputs the string Line read: followed by the user input provided (on the same line). On the next line, it outputs the string Token(s):. This is followed by a list of the tokens in the input provided, each placed on a separate line and indented by a single space. For our purposes, a token is any string in the user input that is delimited by a space (i.e., basically a word). The string n token(s) read is then outputted on the next line (of course, n is replaced with the actual number of tokens read). Finally, a blank line is outputted before prompting for user input again. The process repeats until the command exit is provided. Hints: (1) An array of 256 characters for the user input should suffice (2) To get user input, fgets is your friend (3) To compare user input, strcmp is your friend (4) To tokenize user input, strtok is your friend Turn in your .c source file only that is compilable as follows (filename doesn't matter): gcc -o prog1 prog1.c Make sure to comment your source code appropriately, and to include a header providing your name.

You are hired to design a database for a fitness center. As the fitness center is expanding with more than one branch, they want to create a database to keep track of its customers, facilities and employees. Each branch has a unique id and address (building number, street, district, and city). A branch may have more than one facility (e.g. swimming pool, spa, etc.). Each facility must belong to only one branch, and the information for a facility is name and fees. In addition, each fitness branch offers different classes (such as Yoga, Pilates, Zumba, etc.). All classes should be led by at most one trainer, who is an employee.

Employees must work at one and only one branch. Each employee has an id, name, address (building number, street, district, and city) and can have multiple phone numbers. An employee can only be an admin, managing the facility or working as a clerk, or a trainer. An employee cannot be a trainer and an admin because the trainer id compensated an hourly wage while an admin staff paid a monthly salary. Trainers can train individual customers at different time sessions.

A customer must register at one branch. Each customer has a membership number, name (stored as first name and last name), email, and only one phone number. A customer can join more than one class or uses any number of facilities. A customer may also decide to be trained by at most one personal trainer.

Given the above description:

1. Draw an ERD for the database, identifying the following:
   1. All the entities, attributes and relationships
   2. Primary key and (discriminator in weak entity, if any). Don’t forget each entity has to have PK.
   3. Participation and cardinality constraints. (Explain your choices for two constraints- i.e. identify the words the guided your decision)
   4. Specialization and completeness constraints (if there is an ISA relationship).

2. Write a schema for two entities and two relationships of your choice. Remember, sometimes a relationship is better not be represented in a separate schema; if this is the case with your chosen relationship explain what you will do.
3. Please use a tool to draw the ERD exactly draw it use the word microsoft to make it clear answer .

Variables typically included in a multivariate demand function (other than the price and quantity of the item the demand function represents) are consumer tastes and preferences, the number of buyers, spendable (disposable) income, prices of substitute goods, prices of complementary goods, advertising expenditures, weather, and expectations. Recalling that the price of the item being considered is placed on the vertical axis, and the quantity on the horizontal axis, the other variables are termed demand shifters. Please answer the following questions about the affect changes in other variables might have on the demand for the item. These changes will either cause demand to increase (shift right) or decrease (shift left). Use either word as applicable, for the short answer.

1. Small fire extinguishers can be refilled, must be serviced and inspected annually, and must be pressure tested every five years. Additionally, there is a safety regulation that arbitrarily declares them obsolete after 25 years (after which the code prohibits their commercial use, repair, or recertification). Commercial businesses are required by fire codes to have certified extinguishers that meet the code regardless of the extinguisher’s operability.   The effect of this regulation is to ________________ the demand for new extinguishers, rather than recertifying older ones.

2. Retail businesses (such as Best buy, Barnes and Noble and other brick and mortar retailers) continually encourage their trade associations to lobby Congress to impose sales taxes on internet sales. They want internet sales taxed as a way of __________________ the demand for the merchandise physically stocked in their stores.

3. Compressed Natural Gas (CNG) powers vehicles well, and is an almost pollution-free fuel. If factory equipped, vehicles can switch between using either CNG or ordinary gasoline. It costs under $4000 extra to buy such a factory-equipped auto. However, the auto industry makes little effort to promote the use of CNG. Instead, the auto industry is rushing to introduce battery-powered autos that use expensive, heavy and dangerous Lithium Ion batteries. Suppose the government sufficiently subsidized the installation of CNG pumps at public service stations. The effect might _________________ the demand for CNG powered autos.

4. Government-promulgated rules and regulations specify ever stricter building codes and safety standards, more encompassing caloric maximums for fast foods, higher automobile gas mileage minimums, tighter pollution emission standards, etc, etc. Free market advocates vociferously and vocally condemn these as unnecessary market interferences that increase the production cost of domestically produced goods. Yet the same advocates are among the strongest enforcers of these standards and regulations because they sell and install the new items the codes require. This contradiction is readily explained by realizing that increasing regulations and standards actually ______________ the demand for code-mandated items they sell/manufacture relative to imports.

5. Fast food chains have responded to government mandates by publishing caloric values of the foods they sell and by offering healthy menu alternatives in addition to their traditional high fat, high calorie offerings. Nevertheless, the fast-food chains’ public promotion and advertising continues to stress the supersizing and/or high calorie, high fat food items they are famous for (think supersized French fries and drinks:-)). They are really trying to _____________ the demand for the high dollar supersized choices by not promoting the healthy alternatives.

Variables typically included in a multivariate supply function (other than the price and quantity of the item the supply function represents) are prices of other goods that use similar input resources for production, expectations, the number of suppliers, techniques of production, taxes and subsidies, prices of input resources, and weather. Please answer the following questions about the affect changes in other variables might have on the supply of the item. These changes will either cause supply to increase (shift right) or decrease (shift left). Use either word as applicable, for the short answer.

       1. Regents of Oklahoma colleges and universities are allowing schools to develop an increasing number of certificate programs. These are two-year programs consisting of just the advanced specialized courses in a field. Upon completion, the student receives a certificate of completion rather than the traditional degree. They hope this leads to an _________________ supply of narrowly-trained specialists needed to meet shortages in specialized skills..

      2. Tablet computers have proliferated. In the five years after the Apple iPad™ was introduced, most technology companies have introduced their own cheaper versions. These same companies are also _________________ the supply of desktop computers they produce.

      3. New York, with encouragement from its Mayor, has passed a city ordinance limiting the maximum size of sugared, high calorie drinks that can be sold within their city limits. This is an attempt to _______________ the supply of these obesity-causing beverages.

      4. In July, 2013, the world price of oil began spiking above $100 per barrel. Egyptians were rioting and calling for the resignation of their president (which the military did indeed achieve). This turmoil likely triggered expectations of a future _______________ in the supply of petroleum from mid-eastern countries.

      5. Obesity is now a medically certified disease (which may mean insurance claims for medical treatment of it might be paid). If so, medical schools’ supply of doctors specializing in obesity treatment will likely ___________ .