Exp19_Excel_Ch08_Cap_Golden_State_5K

Project Description:

You are a volunteer for the Golden State 5k, an annual 5k held across several cities in California to raise money for at risk youth. As part of your duties, you track donations, volunteer information, and race results. This year you have decided to use Excel to calculate frequency distribution by age and time, calculate various descriptive statistics, and forecast participation rate as well as donation rate for 2025.

Start   Excel. Download and open the file named Exp19_Excel_Ch08_Cap_GoldenState5k.xlsx. Grader has automatically added   your last name to the beginning of the filename.

Ensure the RaceResults worksheet   is active, then use the FREQUENCY function to calculate the frequency   distribution of the race results in column D. Place your results in the range   G4:G9.

Enter a function in cell F22 to   calculate the correlation between age (Columns C) and race time (Column D).

Enter a function in cell G22 to   calculate the covariance between age and race time. 

Enter a function in cell H22 to   calculate the variance of the ages in the data set. Note this is a sample of   data not a population.

Enter a function in cell I22 to   calculate the standard deviation of the ages in the data set.

Ensure the Data Analysis ToolPak   add-in is active. Use the Data Analysis ToolPak to create a histogram with   chart output starting in cell H12 based on the ages of the runners surveyed.   Use the range F13:F18 as the Bin Range. Ensure that Chart output and   Cumulative percentage is included in the results. Place the upper left hand   corner of the chart in cell L13.

Ensure the VolunteerInfo   worksheet is active. Use the Data Analysis ToolPak to perform a single factor   ANOVA on the range C5:E21 (Including column lables). Place the results   starting in cell G5. 

Create a Forecast Sheet that   depicts year over year growth in participation for the city of Los Angeles.   Set the Forecast end year as 2025 and place the results on a new worksheet named 2025Forecast.

Ensure the Participants   worksheet is active then create a scatter plot chart that places the   Participant observations on the X axis and the Donation dollars on the Y axis   (do not include column headings). Add the chart title Participant   Forecast and a   linear trendline to the chart that also shows the Equation and the R-square.

Enter a function in cell F6 to   calculate the intercept of the linear trendline created in the prior step.

Enter a function in cell G6 to   calculate the Slope of the linear trendline.

Enter a function in cell H6 to   calculate the R-square of the linear trendline.

Enter a function in cell I6 to   calculate the Standard Error. 

Use the FORECAST.LINEAR function   in cell F9 to forecast potential donations once the goal of 20,000   participants is reached. Format the results as Currency.

Complete your analysis by adding   formulas in the range G9:H9 to calculate the high and low thresholds of the   forecast.

1.Code writing
The weight of water is 62.42796 pounds per cubic foot.Write a complete C++ program to input the length, width, and depth of a pool in feet. Compute the volume (Volume is the length times the width times the depth) and multiply this by the weight of a cubic foot of water.Checkpoints: The weight of water must be declared as a pound defined global constant; must prompt the user for each dimension separately; and, output must be one digit to the right of the decimal point.Write all necessary statements. Use no function other than main().. No arrays, no loops. (20 points)Sample run:Enter length (ft): 30.6
Enter width (ft): 15.2
Enter depth (ft): 8.0
Weight: 232291.9 pounds2.Code writing

 Complete the program below writing by writing the prototypes and function definitions for getData() and for calBMR(). Make no changes to main()!Function getData() is to prompt the user for and input the person’s weight, height (in inches), age, and ‘F’ for female and ‘M’ for male. Make sure that the program is not case sensitive and exit the program if there is a data entry error. The function calcBMR() should calculate and return the basil metabolic rate (BMR).For Women: BMR = 655 + 4.3 * weight + 4.7 * height in inches + 4.7 * ageFor Men: BMR = 66 + 6.3 * weight + 12.9 * height in inches + 6.8 * age#includeusing namespace std;// Write the prototypes for getData() and calcBMR()__________________________________________________________________________________________int main()
{
// Local Declarations
double weight, height, age;
char sex;
double valBMR;
//Call function to input person’s information
getData(weight, height, age, sex);
//Call function to calculate BMR
valBMR = calcBMR(weight, height, age, sex);
// Output
cout << "BMR: " << valBMR << endl;return 0;
}// main
//Define functions getData() and calc()HTML Editor Keyboard Shortcuts

3. Code writing
Meridian Corporation of Fremont is trying to decide whether to reward employees who carpool to work. The proposed plan is to pay each employee in the carpool $ 0.08 per mile if the minimum passenger efficiency of 25.0 is met. The passenger efficiency is calculated asP = nm
Gwhere n is the number of people in the carpool, m is the distance traveled in miles and G is the number of gallons of fuel used.The file opened in part A (do not open it again but do have a reference to it as a parameter) contains data on existing carpools. The input file represents each existing carpool as a line of data containing the number of people in the carpool, the total commuting distance for a five-day work week, and the number of gallons used. Write a function called calcEfficiency to process this file until the end of data. Calculate the passenger efficiency for each carpool and if the efficiency is greater than 25.0 then output the passenger efficiency and the amount to be rewarded to the screen. Use no arrays! Paste in only the function definition – not main() even it you wrote it to test your program.Sample carpool.txt2 80 4
3 125 10.5
2 350 15.9Sample output Screen:Efficiency Money
40.0 $ 6.40
35.7 $10.00
44.0 …

4. Assume #includeGivenifstream fpIn;Write a statement to open a file called carpools.txt and assign the pointer to fpIn. If the file cannot be found, then print out the message No such file and exit the execution of the program.

a rectangle

Develop an APA-formatted paper that presents a detailed analysis and research-based information pertaining to ALL the following topics:

• Describe the two key abilities brought by the data discovery technology.
• List and explain types of data flaws and techniques and methodologies used to mitigate the risks that may be introduced by the flaws of the data and make data more meaningful to organizations.
• List and demonstrate the types of the data applicable to different industries by looking at successful case studies of well-known organizations.

Discuss what is Network capacity Planning and how do you measure/determine the capacity of your network? Are there any tools to assist you in network capacity planning?

Information technology in the workflow of business processes is the topic

In a minimum 5-pages, develop an introduction where you clearly explain the overall research topic, literature gathering process, and the scope and organization of the literature review. The introduction should conclude with a paragraph that describes the sequence of the literature you will include and the literature analysis process. After the introduction, you should incorporate possible headings/subheadings that you plan to cover and include at least 20 scholarly references.

Deadline is in 3hrs

everything should be in apa format

and can i have turnitin report

 Given the information presented in Lesson 1 and the materials from “Assignment: Executive Summary on Risk Analysis,” your task for this assignment is to:

• Identify at least five risks to the IT resources.
• Write an executive summary report that describes:
  • The importance of a security policy
  • Methodology to implement the policies to mitigate the identified risks

Required ResourcesMaterials from Assignment: Executive Summary on Risk AnalysisSubmission Requirements

• Format: Microsoft Word
• Font: Arial 10-point size, Double-space
• Citation Style: Follow your school’s preferred style guide
• Length: 500 words minimum

Evaluation Criteria and Rubric

1. Incorporate the risk analysis executive summary from Lesson 1
2. Support the importance of a security policy in the executive summary
3. Suggest methodology to implement the policies to mitigate the identified risks

This Assignment is an implementation of a small simulation program. It is a simulation of a process scheduler of a computer system. This simulated scheduler is a very small, simplified version, which reflects some of the basic operations of a typical process scheduler. 

To successfully finish the program, you are expected to:
know how to define and use a user-defined comparator

knowhow to use Java’s PriorityQueue.
know how to write a small simulation program. 

Part 2: – Project Implementation – due Nov 20st @ 11:00 pm:

Report 2 Contents:

1) Project goals.

2) Database description: A general description of the database, what data is stored in the database.

How the database will benefit the users.

3) Data model & design:

o Completed ER/EER diagram; 8 tables 

 MUST use https://www.draw.io to draw the ER diagram, and then take a

snapshot.

 Include a snapshot of the diagram in the report.

o Business rules.

o Data dictionary: For each one of the tables, list columns, data types, column restrictions,

column descriptions.

4) Implementation:

o Use MySQL Server and MySQL Workbench to create the database/tables.

 Include a snapshot of the SQL code in your report

o Populate the each table with a minimum of 20 rows of sample data. Make sure the

entered data is descriptive (not just random numbers and letters.

 Include a snapshot of the SQL code in your report.

o Use MySQL Server and MySQL Workbench to write/run the SQL queries below. For

each query, provide the following in Report 2:

 Snapshot of the code and the output in the report.

 In about 2 lines, explain what the query returns.

Queries:

 1 trivial query. Simple select with ordering.

 2 medium difficulty queries. Queries that use composite condition for selection,

computations, aggregate function and grouping.

 1 query that uses subquery.

 2 queries that uses join (1 inner join, 1 left or right outer join).

 1 view (query must use join – hint: you can use one of the queries from the

previous question).

 1 query that uses union.

 1 custom stored function.

 1 custom stored procedure.

Please find the attachement