Metode Statistik untuk Ilmu dan Teknologi Pangan

ARA Djamaris

Publication date

2018

Publisher

Download E-book

Description

Buku ini terdiri 7 bagian dan memberikan contoh soal dan pertanyaan untuk pendalaman materi. Isi buku ini adalah statistik aplikatif dimana setiap kasus disajikan dengan menggunakan bantuan program komputer yaitu Mircosoft Excel dan SPSS. Buku ini juga memberikan penjelasan tentang statistik yang umum digunakan dalam proses pengolahan, pengembangan produk dan juga perilaku konsumen. Khusus untuk BAB 7 tentang evaluasi sensori dan data konsumen hanya menjelaskan secara umum, penjelasan lebih detail tentang ini akan dijelaskan pada buku terpisah.

Pada kesempatan ini penulis ingin mengucapkan terima kasih kepada sivitas akademika Universitas Bakrie atas saran dan masukannya selama penulisan dan penerbitan buku ini. Besar harapan penulis semoga buku ini bermanfaat dan tentunya tidak ada gading yang tidak retak, maka penulis juga membuka kritik dan saran dari pembaca. Selamat membaca.

Statistika Bisnis

This is a playlist on YouTube that contains 19 videos on Excel Basic & Intermediate. The playlist is created by Aurino Djamaris and covers topics such as creating Excel equations and graphs, data analysis, and formatting tables. 

Excel Basic & Intermediate

This is a playlist on YouTube that contains 19 videos on Excel Basic & Intermediate. The playlist is created by Aurino Djamaris and covers topics such as creating Excel equations and graphs, data analysis, and formatting tables. You can access the playlist at 1.

Excel Data Validation: Preventing Duplication in User Sheets

Excel is a powerful tool that allows users to manage and analyze large amounts of data. One of the most useful features of Excel is data validation, which ensures that the data entered into a spreadsheet meets certain criteria. This article will focus on how to use data validation to prevent duplication in user sheets.

1. What is Data Validation?

        Data validation is a feature in Excel that allows you to define restrictions on what data can or cannot be entered into a cell. You can configure data validation to prevent users from entering invalid data or data that doesn't conform to specific rules.

2. Preventing Duplication with Data Validation

One common use of data validation is to prevent duplicate entries in a column. This is particularly useful when you're dealing with large datasets and need to ensure that each entry is unique. Here's how you can set up data validation to prevent duplicates:

Step 1: Select the Range

First, select the range of cells where you want to prevent duplicates. For example, if you want to prevent duplicates in column A, you would select all the cells in that column.

Step 2: Set Up Data Validation

Next, go to the 'Data' tab on the Excel ribbon and click on 'Data Validation'. This will open the Data Validation dialog box.

Step 3: Define the Validation Criteria

In the Data Validation dialog box, set the 'Allow' field to 'Custom'. In the 'Formula' field, enter the following formula:

`=COUNTIF($A$1:$A$1, A1)=1`

This formula counts the number of times the value in cell A1 appears in the range A1:A1. If the count is more than 1, the formula returns FALSE and the data validation rule is violated.

Step 4: Set Up an Error Alert

You can also set up an error alert that will display a message when a user tries to enter a duplicate value. To do this, go to the 'Error Alert' tab in the Data Validation dialog box. Check the 'Show error alert after invalid data is entered' box, and enter a title and error message.

Step 5: Apply the Data Validation Rule

Finally, click 'OK' to apply the data validation rule. Now, if a user tries to enter a duplicate value in column A, they will see an error message and will not be able to enter the duplicate value.

3.  Examples

Let's say you have a spreadsheet where you're tracking sales leads. You have a column for email addresses, and you want to make sure that each email address is unique. You could use data validation to prevent duplicate email addresses from being entered.

Or, perhaps you're managing a project and have a spreadsheet where you're tracking tasks. Each task has a unique ID number, and you want to ensure that no two tasks have the same ID number. Again, you could use data validation to prevent duplicate task ID numbers.

4. Conclusion

Data validation is a powerful tool that can help you ensure the integrity of your data. By preventing duplicates, you can avoid errors and inconsistencies that could lead to inaccurate analysis or decision-making. So the next time you're working with a large dataset in Excel, consider using data validation to keep your data clean and accurate.

Unveiling the Potential of Excel's Goal Seek Function: Business Applications and Examples

Microsoft Excel, for decades, has been a powerful tool in the arsenal of business and data professionals. Among its multitude of functions and features, one particularly compelling tool is Goal Seek. Primarily used for decision making and problem solving, Goal Seek is the hidden gem that every business should master.

## What is Goal Seek?

Goal Seek is an Excel function that allows you to find the necessary input value to attain a desired output. It's an excellent tool when you know the desired result, but are unsure about the inputs required to achieve it. For instance, if you want to reach a specific profit level but are uncertain how much sales volume is required, Goal Seek can provide the answer.

## How to Use Goal Seek in Excel

To access Goal Seek, navigate to the 'Data' tab in Excel and select 'What-If Analysis' under the 'Forecast' group. Then select 'Goal Seek'. You'll then need to fill out three fields:

1. **Set Cell:** The cell you want to change (the output). It usually contains a formula that refers to the changing cell.

2. **To Value:** The goal or the desired value you want the set cell to reach.

3. **By Changing Cell:** The cell you'll adjust to reach the goal.

Click 'OK', and Excel will adjust the changing cell to provide the desired result in the set cell.

## Goal Seek in Business: Examples

### Example 1: Sales Targets

Imagine you're a sales manager and your team needs to hit a quarterly revenue target of $200,000. You know that each sales rep has an average deal size of $5,000. The question is, how many deals does the team need to close to meet the target?

With Goal Seek, you can find the answer. Assuming cell A1 contains the average deal size ($5,000), and cell B1 contains the number of deals (unknown), your total revenue (cell C1) is calculated by the formula =A1*B1.

In this scenario, you can use Goal Seek to set cell C1 (total revenue) to the value of $200,000 by changing cell B1 (number of deals). Excel will then calculate the required number of deals to meet your revenue target.

### Example 2: Break-Even Analysis

Goal Seek can be valuable for conducting break-even analyses. Suppose you're a product manager and need to calculate how many units of a new product must be sold to cover costs. 

Let's assume fixed costs (cell A1) are $50,000, variable costs per unit (cell B1) are $10, and the selling price per unit (cell C2) is $20. The total cost (cell C1) is given by fixed costs plus variable costs times the number of units, =A1+(B1*D1). Your total revenue (cell D2) is the selling price times the number of units, =C2*D1.

You can use Goal Seek to set the total cost cell (C1) equal to the total revenue cell (D2) by changing the number of units cell (D1). Goal Seek will calculate the number of units that must be sold to break even.

## Conclusion

Excel's Goal Seek function is an essential tool for business professionals. It provides an efficient way to perform critical analyses and make informed business decisions. The examples above barely scratch the surface of its potential uses. With a firm grasp of Goal Seek, you can navigate the uncertainties of the business world and steer your company towards its objectives with ease.