The entertainment industry

Assignment Help Basic Statistics
Reference no: EM131548754

Objectives:

Create an Excel workbook with external resources

Design a basic report table

Apply professional formatting to a data table

Prepare an Excel document for printing

Enter and format date data

Construct basic formulas

Step 1: Gather the data

Research and locate any data you are interested in for the entertainment industry, or alternatively, research demographics information you feel are related to the industry.

Your data must be different from other classmates. Review post summaries completed before yours to ensure there is no duplication.

The data should be a minimum of 1 column x 5 rows (or 5 columns by 1 row) and should include numbers/currency that can be calculated with a formula.

Step 2: Start the workbook and create formulas

Copy the data from the original source in your research.

In a new Excel workbook, paste the data with the data collected using the Paste Special option in the Edit Menu item.

Choose Paste "Values" or Paste "Unicode Text" (Option of Values / Unicode Text will vary depending on data collected). Note: If data does not copy/paste easily into the document, it may need to be hand-typed.

Using the data collected: Create at least 2 unique formulas or functions to analyze the data.

Below is a tutorial discussing how to bring the data into Excel.

Below is a video discussing the creation of the formulas.

Step 3: Format the data set

Formatting should include:

Change at least one font color

Change at least one font size

Change at least one type of font

Apply a background fill to your labels for the categories

Professional alignment of text and/or numbers

Formatting of currency if appropriate. For any number over 1,000 that is not currency, there should be commas with no decimals

Resizing of columns or rows if necessary to ensure all data and categories can be viewed easily

Insert at least two symbols with the Excel symbol browser to help emphasize areas of interest in your data

Step 4: Worksheet Design Guidelines

File saved with assignment number and first name, last initial. For example: A1AprilW.xlsx

Headers contain name of Assignment (unless otherwise instructed) on each worksheet.

Footers contain creation date, last opened date, and student's name on each worksheet. Creation date is hand-typed. Opened date will change every time assignment is opened.

Excess sheets removed (no unused extra tabs)

Each tab contains short worksheet name (renamed, should not be: Sheet1 or Chart1, etc)

Cell formatting appropriate: text and number formatting correctly used and appropriate to the scenario. Financial figures should have currency or accounting format. Figures over 100havenodecimals.Figuresunder 100 will show two decimals.

No cells contain errors (all green triangle cells resolved)

At least one cell comment on each worksheet to document notes from class OR to emphasize outcomes (explain why you chose a certain formula, certain data or explain the outcome of data analysis)

Designed for both Normal and Page Layout views but delivered in Page Layout view with the correct perspective chosen (either portrait or landscape) - ensure that neither data nor charts cross page breaks (one page wide).

Here is a refresher on the worksheet design guidelines.

Note: this is the same video from the month-long tutorials area if you already viewed it.

Step 5: Submission

In the discussion board area:

Provide a brief explanation to other students of the data you selected. Include details such as time frame pulled, subject area, basic content of the data.

In at least one paragraph, describe how you feel the data you selected relates to your field of interest.

Include a citation/reference for the data source.

Questions Cloud

 Write the above second order equation : Write the above second order equation as a system of first order equations. How do most individuals monitor and control their cash flow : How do most individuals monitor and control their cash flow? Share an example of something that you had to budget and plan to pay for. Explain threats to validity and how design will address them : The ability to read, understand, critique, and integrate research studies and to design a study to address a gap in the research literature is a vital. What should investors par for march hair : With required rates of return at 14 percent, what should investors par for March Hair? The entertainment industry : Research and locate any data you are interested in for the entertainment industry, or alternatively, research demographics information. Solely on the internal rate of return rule : If the required rate of return is 15.5 percent, should you accept the investment based solely on the internal rate of return rule? Why or why not? What are the three most significant lessons : What are the three most significant lessons that I have learned from studying issues related to diversity, equity, and social justice in this course. Personal or professional decision-making : When have you had to consider risk and return in personal or professional decision-making? How the liquidity position of finance companies : Explain how the liquidity position of finance companies differs from that of depository institutions such as commercial banks.

Write a Review

Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

Estimate the population mean

Estimate the population mean

Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

Find out the probability

Find out the probability

Linear programming models

LINEAR PROGRAMMING MODELS