Suppose annual salaries for sales associates from Geoff's Computer Shack have a mean of $32,500 and a standard deviation of $2,500.

you created a portfolio by purchasing  2000 shares of x company 2 dollar each, and 2000 shares of y 1 dollar each.

During the year   x company declared a cash dividend of   200 cents per share, while y did not give any dividend.

After one year you sold your both the shares. x at 1.8 dollar each and   y at 1.3 dollar each.

Calculate the HPY for your portfolio.

Generate comparative boxplots for: Male data between 2000 and 2015, Female data between 2000 and 2015, Both Sexes data between 2000 and 2015

Using the data from 2000, estimate the mean adult mortality rates for male, female and both sexes for the world population with 95% confidence.

Using the data from 2015, estimate the mean male, female and both sexes adult mortality rates for the world population with 95% confidence.

Estimate the mean difference (with 95% confidence) between: Male adult mortality rates of 2000 and 2015, Female adult mortality rates of 2000 and 2015, Both sexes adult mortality rates of 2000 and 2015

According to the Original Tooth Fairy Poll sponsored by Delta Dental, the average payout per tooth by the Tooth Fairy was $1.50 in 2000. In 2017, the payment per tooth went up to $4.66.[1] What has been the average annual growth rate of Tooth Fairy payment from 2000 to 2017? The S&P index value in 2000 is 1360.16,[2] and the index value is 2294.69 in 2017.[3] What has been the average annual growth rate of the S&P 500 from 2000 to 2017?

The mean time to assemble a piece of furniture is 52 minutes. Suppose the the assembly times are normally distributed with a standard deviation of 4.3 minutes. What percentage of assembly times fall between 47.7 minutes and 56.3 minutes?

Use the Empirical Rule

Question 1 options:

question 2

A survey found that the mean retail price per litre of premium grade gasoline is $1.89. Suppose the retail prices per litre are normally distributed with a standard deviation of $0.18. Between what two prices do 68% of the prices per litre fall?

Use the Empirical Rule

Question 2 options:

QUESTION 3

The mean time to assemble a piece of furniture is 52 minutes. Suppose the the assembly times are normally distributed with a standard deviation of 4.3 minutes. What percentage of assembly times fall below 39.1 minutes?

Use the Empirical Rule

Question 3 options:

QUESTION 4 A survey found that on average adults sleep 6.8 hours per night. Suppose that the hours per night are normally distributed with a standard deviation of 1.3 hours. 16% of the times are above what value?

Use the Empirical Rule

Question 4 options:

QUESTION 5

The mean time to assemble a piece of furniture is 43 minutes. Suppose the the assembly times are normally distributed with a standard deviation of 3.7 minutes. What percentage of assembly times are above 50.4 minutes?

Question 5 options:

Data Engineers regularly collect, process and store data. In this task you will develop a deeper understanding of how C programming language can be used for collecting, processing and storing data. In this assignment you get the opportunity to build an interactive program that can manage the list of flights departing Sydney Airport.

The list is stored as an array of flight_t type structures

flight_t flights [MAX_NUM_FLIGHTS];

The flight_t is a structure typedef for struct flight. The struct flight contains the following fields

• flightcode - array of MAX_FLIGHTCODE_LEN+1 chars (string)
• departure_dt - a structure of date_time_t type as defined below
• arrival_city - array of MAX_CITYCODE_LEN+1 chars (string)
• arrival_dt - a structure of date_time_t type as defined below

Note that we now have a struct nested within a struct. The date_time_t is a structure typedef for struct date_time. The struct date_time contains the following fields,

• month - integer between 1 and 12 (inclusive)
• day - integer between 1 and 31 (inclusive)
• hour - integer between 0 and 23 (inclusive)
• minute - integer between 0 and 59 (inclusive)

Your program interacts with the nested struct array in your memory (RAM) and simple database file in your hard disk. It should provide the following features:

1. add a flight

Add a new flight to the flights through the terminal. You should collect the input by asking multiple questions from the user.

Enter flight code>
Enter departure info for the flight leaving SYD.
Enter month, date, hour and minute separated by spaces>
Enter arrival city code>
Enter arrival info.
Enter month, date, hour and minute separated by spaces>

2. display all flights to a destination

Prompt the following question

Enter arrival city code or enter * to show all destinations>

The user may enter the abbreviation of MAX_CITYCODE_LEN characters for the arrival city. The program should display all flights to the requested destination. If the user input is *, display all flights.

The display format should is as follows.

Flight Origin          Destination
------ --------------- ---------------
VA1    SYD 11-26 09:54 LAX 11-26 18:26

Pay attention to the strict formatting guide:

• Flight - left aligned, MAX_FLIGHTCODE_LEN (i.e. 6) chars at most.
• Origin and Destination
• City - left aligned, MAX_CITYCODE_LEN (i.e. 3) chars at most.
• Month, day, hour, minute - two digits with leading zeros

3. save the flights to the database file

Save the flights in the hard disk as a binary/text file named database. You may use your own format to save the data. You should overwrite if database file already exists.

4. load the flights from the database file

Read the database file and put the data into flights. You may only read the data files created by your own program. You should overwrite the flights array you had in memory when loading from the file.

5. exit the program

Exit the interactive program.

Careless Users

Your program may assume that the input data type is always the expected type i.e. when the program expects an integer the user must enter an integer. However, a careless user may enter an input that is outside the expected range (but still of the expected data type). Your program is expected to handle careless users. e.g.

Enter choice (number between 1-5)>
-1
Invalid choice

Or a careless user may try to add 365 as the month (month should be between 1 and 12). Or try to add a flight to the flights array when it already contains MAX_NUM_FLIGHTS flights, etc.

Run the sample executable to futher understand the expected behaviour.

Check the formatting of the flightcode

WARNING: Attempting this feature is recommended only for advanced students who enjoy a small challenge. You may need to do your own research, but more than that you may have to be creative. By using incorrect techniques you could very well introduce more bugs in your code and it could be time consuming. The special techniques required for this purpose will not be assessed in the final exam.

Your program should be able to check the format of the flightcode. The first two characters of the flightcode should be uppercase letters (A-Z) representing the airline. The rest of the flightcode should be numerals (0-9) representing the flight number. There must be 1-4 numerals as the flight number part of the flightcode. No spaces in the flightcode.

Run the sample executable to further understand the expected behaviour.

The database file

It is up to you to create your own data storage format for the database file. Your program should be able to read the database that was created by itself. You can create the database as a text or binary file.

You do NOT need to be able to create a database identical to the database of the sample executable. You do NOT need to be able to read the database of the sample executable.

You are free to use the following C libraries in this program ONLY:

stdio.h
stdlib.h
string.h

In this project you will be provided a set of specifications to create an entity-relationship diagram and design accompanying table layout using sound relational modeling concepts and practices. The relationships between the entities and the attributes for the entities will be identified and described. This database will provide the foundation for the follow-on project. The following paragraphs provide the background and summary of the business requirements. You are a database consultant with Premier Software, LLC and have been assigned to develop a database for the Acme video store in town. Acme has been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with Acme to discuss their business, and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent; therefore, there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices to them are based on the quantity of their shipment and the past business they have done with each company. The price of a DVD for a movie might be different than the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors, and at different wholesale prices. Each video and DVD have a unique identification number that Acme assigns in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number Acme assigns in addition to the title, and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to Acme and the information from these catalogs must be included in the database. Acme needs to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion there are discount prices for certain movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the academy awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. Acme needs to keep only basic information on customers in their database, such as name, address, telephone numbers, etc. There must be no limit to the number of video and/or DVD copies of a movie that Acme can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and academy awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People's Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.

Using this information, you should:

1. Determine and list your entities. Then describe fully the relationships between entities via pairs of sentences that indicate the two components of the total relationship in both directions between the entities. Relationships may be unary, binary, or ternary with respect to entities. You should not have any many-to-many relationships.

2. Begin the database logical design by identifying the entities, relationships between entities, and entities' attributes as we have done in this course. Use the same entity/relationship diagram (ERD) notation as used in class for entities, attributes, and relationships. Sketch your ERD by hand or a drawing program (e.g., Visio, PPT, SQL Modeler …) on one single 8-1/2" x 11" page (8-1/2" x 14" maximum), labeled "Acme Video Store Database E/R Diagram." Your ERD should not have any many-to-many relationships between entities. Make sure that all relationships between entities are one-to-many to facilitate the construction of relational database tables.

3. Complete the logical database design and start the physical database design by creating metadata (i.e. documentation) that describes the table(s) created from each entity and the column(s) created from each attribute in the ERD. Attributes should be self-describing. Particular attention will be given to the proper specification of all primary key (via "PK") and foreign key (via "FK") columns in the table layouts. These should match your ERD exactly. Begin these descriptions on a page labeled "Proposed Database Tables and Columns based on E/R Diagram." All tables must be 3rd Normal Form. Indicate any and all assumptions that were made.

PLEASE ANSWER THIS QUESTION: I WILL APPRECIATE IT