Solved Exp19_Excel_Ch08_Cap_Golden_State_5K

  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.

Discussion

 

Discuss in 500 words or more best practices for incident response in the cloud. Refer to at least one incidence response framework.

Use at least three sources. Use the Research Databases available from the Danforth Library not Google. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.  Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources using APA format. Use the quotes in your paragaphs.  Stand alone quotes will not count toward the 3 required quotes.

Copying without attribution or the use of spinbot or other word substitution software will result in a grade of 0. 

Write in essay format not in bulleted, numbered or other list format. 

Ethics of Human Cloning

 

For this assignment, you are to assume that all involved have moral convictions (not political or economic) associated with their side of the ethical debate. Your job is to look at both sides as objectively as possible to make an evidence-based judgment.

For this assignment, you are asked to present your judgment on the current ethical debate related to human cloning. You can present the current state of the debate, pro and con arguments, and your judgment using your choice of media. For example, you could choose to create an essay, a PowerPoint presentation without audio, or use Prezi. Please do not create a video recording for this presentation.

Your completed presentation must include:

  • The current state of the debate, include at least one (1) external reference
  • An argument in favor of human cloning, include at least two (2) external references
  • An argument against human cloning, include at least two (2) external references
  • A detailed explanation of which argument you found most convincing
  • A step-by-step description of how you came to your conclusion, include any additional references (besides the ones you already used) needed to support your process.

Be sure to use appropriate sources for the external references required for this assignment.

Software -6B

Discuss one type of systems that may require software safety cases, and explain why safety cases are required for your proposed system ? 

Please answer the following

From our weekly chapter reading, digital preservation can be defined as the long-term, error-free storage of digital information, with means for retrieval and interpretation, for the entire time span the information is required to be retained. Though this assessment holds true to the authors, business organizations continue to face significant challenges in meeting their LTDP needs, especially those organizations whose primary mission is to preserve and provide access to permanent records. what considerations would have to be made in developing a long-term archival plan for a company within automobile industry?

Business Intelligence DSS Discussion

How do you know when you have included enough “intelligence” in a decision support

system? Provide 3 examples of user interfaces that support your answer.

Need about 2-3 pages with peer-reviewed references. APA formatted. Attached chapter for the week.

Note: No AI generated content. It gets filtered out in plagiarism check!

PaPer

 Write an essay of at least 500 words discussing the reasons for the two new auditing roles in Oracle 12c. Why did Oracle consider them necessary? What problems do they solve? How do they benefit companies? 

nclude at least one quote from each of 3 different articles. Use the Research Databases available from the Danforth Library (https://libguides.nec.edu/az.php), not Google.   Place the words you copied (do not alter or paraphrase the words) in quotation marks and cite in-line (as all work copied from another should be handled). The quotes should be full sentences (no more, less) and should be incorporated in your discussion (they do not replace your discussion) to illustrate or emphasize your ideas. 

help with python

the images attached are the instructions, but i have been on this for days with no luck, therefore I have attached my own code as well.

import turtle

import random

z = turtle.Turtle() #global

global window

window = turtle.Screen()

dice = []

buttons = []

def drawCenterDot(z, x, y, width, dotwidth):

    z.penup()

    z.goto(x + width / 2, y – width / 2)

    z.pendown()

    z.dot(dotwidth)

def drawCornerDots(z, x, y, width, dotwidth):

    z.penup()

    z.goto(x + dotwidth, y – dotwidth)

    z.pendown()

    z.dot(dotwidth)

    z.penup()

    z.goto(x + width – dotwidth, y – width + dotwidth)

    z.pendown()

    z.dot(dotwidth)

    

def drawOtherCornerDots(z, x, y, width, dotwidth):

    z.penup()

    z.goto(x + width – dotwidth, y – dotwidth)

    z.pendown()

    z.dot(dotwidth)

    z.penup()

    z.goto(x + dotwidth, y – width + dotwidth)

    z.pendown()

    z.dot(dotwidth)

def drawSideDots(z, x, y, width, dotwidth):    

    z.penup()

    z.goto(x + dotwidth, y – width / 2)

    z.pendown()

    z.dot(dotwidth)

    z.penup()

    z.goto(x + width – dotwidth, y – width / 2)

    z.pendown()

    z.dot(dotwidth)

#Defined drawing some spicy dots 😉 

def drawDots(z, dieValue, x, y, width):

    dotwidth = width // 6

    if dieValue == 1:

        drawCenterDot(z, x, y, width, dotwidth)

    elif dieValue == 2:

        drawCornerDots(z, x, y, width, dotwidth)

    elif dieValue == 3:

        drawCenterDot(z, x, y, width, dotwidth)

        drawOtherCornerDots(z, x, y, width, dotwidth)

    elif dieValue == 4:

        drawCornerDots(z, x, y, width, dotwidth)

        drawOtherCornerDots(z, x, y, width, dotwidth)

    

    elif dieValue == 5:

        drawCenterDot(z, x, y, width, dotwidth)

        drawCornerDots(z, x, y, width, dotwidth)

        drawOtherCornerDots(z, x, y, width, dotwidth)

    

    else:

        drawCornerDots(z, x, y, width, dotwidth)

        drawOtherCornerDots(z, x, y, width, dotwidth)

        drawSideDots(z, x, y, width, dotwidth)

def drawDie(z, value, x, y, width, color=’white’):

    z.penup()

    z.goto(x, y)

    z.setheading(0)

    z.fillcolor(color)

    

    z.pendown()

    z.begin_fill()

    for _ in range(4):

        z.forward(width)

        z.right(90)

    

    z.end_fill()

    z.penup()

    drawDots(z, value, x, y, width)

def mouseClick(x,y):

    global dice

    global buttons

    print(“mouse clicked at position ” +str(x) + “,” + str(y))

    

    for button in buttons:

        count = 0

        if isWithin(x, y,button[0],button[1],button[2],button[3]) == True:

            buttonClick(count)

        else:

            count+=1

    for die in dice:

        count = 0

        if isWithin(x,y,die[1],dice[2],dice[3],dice[4]) == True:

            dieClick(count)

        else:

            count+=1

def isWithin(x, y, a, b, width, height):

    if a < x < a + width and b - height < y < b:

        return True

    else:

        return False

def buttonClick(index):

    global dice

    global z

    global buttons

    if index == 0:

        for die in dice:

            die[4] = “white”

    for die in dice:

        if die[4] == “white”:

            die[0] == random.randint(1,6)

def dieClick(index):

    global dice

    global z

    if dice[index][4] == “white”:

        dice[index][4] = “blue”

    else:

        dice[index][4] == “white”

    return drawDie(z, dice[index][0],dice[index][1],dice[index][2],dice[index][3],dice[index][4])

    

def drawRectangle(z, x, y, width, height, line_color,fill_color, Text = “None”):

    z.penup()

    z.goto(x,y)

    z.pencolor(line_color)

    z.fillcolor(fill_color)

    z.pendown()

    z.begin_fill()

    z.setheading(0)

    z.forward(width)

    z.right(90)

    z.forward(width)

    z.right(90)

    z.forward(width)

    z.right(90)

    z.forward(width)

    z.right(90)

    z.end_fill()

    z.penup()

def main():

    global dice

    global buttons

    global z

    global window

    window.bgcolor(“LightPink”)

    window = turtle.Screen()

    z = turtle.speed(0)

    turtle.hideturtle()

    width = 1000

    height = 800

    

    window.onclick(mouseClick, 1, True)

    window.onclick(buttonClick,1, True)

    turtle.mainloop()

    

    

    dice = dice + [random.randint(1,7)]

    return dice

main()

    

    

    

Speaker Notes

I have them in a WORD doc with my Speaker notes. I need bulleted speaker notes per slide can you revise the wording