A digital forensics professional must know basic IT skills, understand computer architecture and networking, and have analytical and investigative skills, as well as strong attention to detail. Why do think all of these skills are necessary? Please explain. 

 What are some of the ways we can manage the distribution channel? After reviewing this week’s resources and your research, consider the various channels of distribution. In your own words identify at least two ways to better manage and an existing channel for a specific product you personally use? Be sure to explain your reasoning behind your selections.The criteria for responses are as follows:

• Your initial response to the discussion question should be 250-300 words. You must have at least one course (our text) and one non-course scholarly/peer reviewed source in your initial posting.  Sources require in-text citations and must be incorporated into the body of the post in addition to a full APA citation at the end of the post. 

Company Name: Walmart.

Product: Product should be used the same as mentioned in previous weeks work.

References: 

https://www.repsly.com/blog/consumer-goods/everything-you-need-to-know-about-product-distribution

ONLY Explain different design decisions for these different user groups on the paper.

Do NOT Design Web Pages

 700 words APA style

 Provide a brief summation (paper: 1 pages) of the affect economics, culture, regulation, religion, education, and customs may have on the ability to market a new product, in a European or Middle Eastern country. APA Format applies. 

Please find the attached document for the questions.

A notable feature of Linux is its ability to accept new device drivers on the fly, while the system is up and running. How is this a useful function?

#Exp19_Excel_Ch05_HOEAssessment_Fine_Art

#Exp19 Excel Ch05 HOEAssessment Fine Art

Project Description:

You are an analyst for a fine art dealer. Customers are especially fond of James C. Christensen’s art. You prepared a list of his artwork: Title (title of each piece of art), Type (the medium, such as Limited Edition Print or Anniversary Edition Canvas), Edition Size (how many copies were produced for purchase), Release date (the month and year the art was released), Issue Price (the original retail price when the art was released), and Est. Value (the estimated current market value). Studying the data will help you discuss value trends with art collectors

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

Before using the Subtotal   command, the data must be sorted by categories.
 

  On the Subtotals worksheet, perform a three-level sort by Status, then by   Type, and finally by Title, all in alphabetical order.

You want to subtotal data to   identify the highest issue prices, estimated values, and percentage change by   the Status category and the Type of art work.
 

  Use the Subtotals feature to insert subtotal rows by Status to identify the   highest (max) Issue Price, Est. Value,   and Change. Then add a second-level subtotal by Type using the same function   and columns.

You want to apply an outline so   that you can collapse values used for the formula in column F. Then you will   collapse the subtotaled rows.
 

  Apply an auto outline and click the collapse button above column F. Collapse   the data by displaying only the subtotals and grand total rows. Set a print   area for the range B1:F48.

A PivotTable can give additional   perspective to data. You will use the Art worksheet to create a recommended   PivotTable.
 

  Use the Art worksheet to create the recommended PivotTable called Sum of   Issue Price by Type on a new worksheet named Sold Out. Mac users create a PivotChart   that includes the Status field in the Filters area, the Est. Values field in   the Columns area, the Type field in the Rows area, and the Issue Price field   in the Values area.
 

  Name the PivotTable Art Type.

Currently, the PivotTable   contains the Issue Price field. You will add the Est. Value field to compare   the difference between total value of the art based on issue price and   estimated value today.
 

  Add the Est. Value field below the Sum of Issue Price in the Values area.

You want to display the average   values instead of the sum of the values in each category.
 

  Modify the two Values fields to determine the average Issue Price and average   Est. Value by type. Change the custom name to Average Issue Price and Average Est. Value, respectively.

Format the two Values fields   with Accounting number type with zero decimal places.

The Summary sheet is designed to   display two key averages from the PivotTable on the Summary sheet.
 

  Display the Summary sheet. In cell B2, insert the GETPIVOTDATA function that   references cell C4 on the PivotTable in the Sold Out sheet. In cell B3,   insert the GETPIVOTDATA function that references cell C9 on the PivotTable in   the Sold Out sheet.

Some art is still available, but   most art is sold out. You want to create a filter to focus on the sold-out   art.
 

  Display the Sold Out sheet. Add the Status field from the field list to the   Filters area. Set a filter to display only art that is Sold Out.

Insert a slicer for the Type   field, change the slicer height to 2 inches, change the button width to 2 inches, and apply the Light   Blue, Slicer Style Dark 5. Cut the slicer and paste it in cell A11.
 

  Note, depending upon the Office version used, the style name may be Slicer   Style Dark 1.

Display the Totals sheet. Insert   a calculated field named Field1 to determine difference between the two   values, Est. Value   and   Issue Price.   Change the custom name to Value Increase.

With the PivotTable on the   Totals sheet displayed, change the Sum of Issue Price and Sum of Est. Value   fields to show values as percentage of column totals.

With the PivotTable on the   Totals sheet displayed, select Light Blue, Pivot Style Medium 6 and display   banded rows.

Display the Porcelains sheet.   Create a relationship between the PORCELAINS table using the Code field and the   CODES table using the Code field.

Create a blank PivotTable from   inside the PORCELAINS table. Add this data to the Data Model. Name the   worksheet Porcelain Pivot and name the PivotTable Porcelain   Values.

Display all tables in the   PivotTable Fields List task pane. Add the Description from the CODES table to   the Rows area and the Issue and Est. Value fields as Values from the   PORCELAIN table. Format the two value fields with Accounting number format   with zero decimal places.

Create a clustered column   PivotChart from the Porcelain Values PivotTable. Cut the PivotChart and paste   it in cell A7.

Add a chart title and type Porcelain   Values. Bold   the title. Change the value axis maximum bounds to $3,000.

Change the PivotChart height to 2.5 inches and the width to 3.7 inches.

Create a footer on all   worksheets (except Art) with your name in the left section, the sheet name   code in the center section, and the file name code in the right section.

Ensure that the worksheets are   correctly named and placed in the following order in the workbook: Subtotals,   Totals, Sold Out, Art, Summary, Porcelain Pivot, Porcelains.

Save and close Exp19_Excel_Ch05_HOEAssessment_FineArt.xlsx.   Exit Excel. Submit the file as directed

Before we execute a project, we must baseline our project.  Search the Internet and ascertain what we mean by “Baselining” our project.  And specifically, which items are baselined?  Stated another way, what items are in the basline? Describe them.

Text

Title: Project Management 

ISBN: 9780134730332 

Authors: Pinto 

Publisher: Pearson 

Edition: 5TH 19

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.

Exp19_Excel_Ch10_Cap_Auto_Sales| Exp19 Excel Ch10 Cap Auto Sales

Exp19_Excel_Ch10_Cap_Auto_Sales| Exp19 Excel Ch10 Cap Auto Sales

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

#Use Get & Transform (Power   Query) to import the file e10c1Agents.csv.   
   Hint: Get Data is located on the Data tab in the Get & Transform Data   group.

Rename the worksheet Agents.
   Hint: Double click the worksheet tab to edit the sheet name.

#Use Get & Transform (Power   Query) to import the Vehicles table from the file e10c1Vehicles.accdb.
   Hint: Get Data is located on the Data tab in the Get & Transform Data   group.

Rename the worksheet Sales.
   Hint: Double click the worksheet tab to edit the sheet name.

#Load the file e10c1Customer_Leads.txt in the Power   Query Editor. Use the Power Query Editor to ensure the first row is used as   Headers. Close and load the table.
   Hint: To open the data in the Power Query Editor click Edit on the Import   window.

Rename the worksheet Customer_Leads.
   Hint: Double click the worksheet tab to edit the sheet name.
 

Add the Vehicles, e10c1Agents,   and e10c1Customer_Leads tables to the data model.
 

  Hint: Manage Data Model is located on the Data tab in the Data Tools group.

#Define the following   relationship:
   Table:
   e10c1Agents
   Field:
   AgentID
   Table:
   Vehicles
   Field:
   AgentID
   Hint: Relationships is located on the Data tab in the Data Tools group.

#Use Power Pivot to create a   PivotTable on Sheet1 starting in cell  B3. Add the Last field from the   e10c1Agents table to the Rows area and  Price from the Vehicles table to the   Values area.
 

  Hint: Power Pivot is an Excel add-in that must be loaded. Power  Pivot can be   loaded by accessing COM add-ins in Excel options. Once  loaded, the Power   Pivot tab is located on the Office ribbon.

Format the range C4:C20 with   Accounting Number Format.
 

  Hint: Accounting Number Format is located on the Home tab in the Number   group.

Insert a Clustered Column Pivot   Chart. Position the chart so the upper left corner is in the center of cell   D3.
 

  Hint: #PivotChart is located on the Analyze tab in the Tools group.

Add the Chart Title Sales.
   Hint: Chart elements can be added or edited on the Design tab in the Chart   Layouts group. 

Rename the worksheet SalesAnalysis.
   Hint: Double-click the worksheet tab to edit the sheet name.