« previous next »

Author Question: When the data are large and when it is difficult to analyze all at once, which of the following ... (Read 81 times)

craiczarry

  • Hero Member
  • *****
  • Posts: 527
on: Jun 24, 2018
When the data are large and when it is difficult to analyze all at once, which of the following feature in Excel is used to make the data more manageable and to develop insights?
 a. Frequency table
  b. Sorting and filtering
  c. Fill color
  d. Charts

Question 2

A multiple regression equation has been developed for y = daily attendance at a community swimming pool, x1 = temperature (degrees Fahrenheit), and x2 = weekend versus weekday, (x2 = 1 for Saturday and Sunday, and 0 for other days of the week.) For the regression equation shown below, interpret each partial regression coefficient: y = 100 + 10x1 + 175x2.


Sweetkitty24130

  • Sr. Member
  • ****
  • Posts: 291
Reply #1 on: Jun 24, 2018
Answer to Question 1

B

Answer to Question 2

The partial regression coefficient for x1 implies that, holding the day of the week constant, a one degree Fahrenheit increase in the temperature will result in an increase of 10 in attendance. The partial regression coefficient for x2 implies that the attendance increases by 175 people on Saturdays and Sundays (assuming a constant temperature).


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

Did you know?

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

Large-Flowered Leafcup Large-Flowered Leafcup
The Taung Child, the first of the australopithecines to be discovered, is the type specimen for Aust The Taung Child, the first of the australopithecines to be discovered, is the type specimen for Aust
Franz Marc, Die grossen blauen Pferde (The Large Blue Horses). Franz Marc, Die grossen blauen Pferde (The Large Blue Horses).
Propaganda to influence public opinion surrounds us, but most propaganda is covert, difficult to ... Propaganda to influence public opinion surrounds us, but most propaganda is covert, difficult to ...
Find a quadractic equation that models the data in standard form Find a quadractic equation that models the data in standard form
Type III curve. Mortality is highest early in life. Data for a desert shrub (Cleome droserifolia). Type III curve. Mortality is highest early in life. Data for a desert shrub (Cleome droserifolia).
Video: Chloroplast Structure & Light Dependent Reactions (Photosystem 1 and 2 Cyclic Electron Flow)

For a complete list of videos, visit our video library